Accessing more than: sql2000

Showing posts with label sql2000. Show all posts

Sunday, March 11, 2012

Add SQL Server 2005 nodes to a SQL2000 cluster

I am trying to add 2 2005 nodes to an existing cluster that has 2xSQL2000
nodes. The cluster is using a SAN with - T, U drives as data and log in node
1, and - V, W drives as data and log in node 2
I want to add SQL2005 nodes, using these drives. When I start the install -
using wizard - I check the box to create a new virtual server (If I leave it
unchecked the install is not cluster aware)
When I get to the step re cluster group resource, I cannot use any of the
drives as they are in use by the existing virtual server.
I tried making a new group, but when I do that I cannot assign the existing
drives to the new groups.
How does one normally acheive this without rebuilding the SAN to add in
extra partitions? Has anyone seen any effective resources about how to do
this?
Thanks
Geoff Tanner
YOu can't add SQL2005 nodes to a SQL2000 cluster and keep two nodes SQL2005
and the other two nodes SQL2000. It's not supported, and makes no business
sense.
Linchi
"Geoff Tanner" wrote:

> I am trying to add 2 2005 nodes to an existing cluster that has 2xSQL2000
> nodes. The cluster is using a SAN with - T, U drives as data and log in node
> 1, and - V, W drives as data and log in node 2
> I want to add SQL2005 nodes, using these drives. When I start the install -
> using wizard - I check the box to create a new virtual server (If I leave it
> unchecked the install is not cluster aware)
> When I get to the step re cluster group resource, I cannot use any of the
> drives as they are in use by the existing virtual server.
> I tried making a new group, but when I do that I cannot assign the existing
> drives to the new groups.
> How does one normally acheive this without rebuilding the SAN to add in
> extra partitions? Has anyone seen any effective resources about how to do
> this?
> Thanks
> Geoff Tanner

Tuesday, March 6, 2012

add linked server

Hi ,
I have tried to add a linked server(sql2000) residing
at location B from Location A (a server computer ,using
SQL 7.0) but i got the error "general network error , pls
check network documentation" I have gotten the correct
login id & pwd from the user at the other end.
have also configured the port#(under Client Utility)
correctly for client connection and also triedthe
sp_addlinkedservers & sp_addsvrlogin already
Is there any dll file needed ? such as DBNET.dll ? to
add linked server from sql ver 7.0 to sql2000 ?
Does it need any specific version of the odbc driver
for SQL Server ? current it's version is 3.70.10.63 i have
tried to add and odbc link but still have the same error
I have no problem when using Query Analyzer from my
client computer AND the user from the other end is able to
add my sqlserver successfully as a linked server. The odbc
driver for SQL Server is 3.85.xx.xx
Appreciate if somebody could help me out as i am doing
some data migration which i have set up some DTS jobs to
copy data daily over instead of one big chunks the day
before migration
many thksmaxzim
Can you show us your creation script?
This example works without creating a linked server
declare @.pid varchar(30)
set @.pid='2450'
select id from openrowset('sqloledb',
'server';'sa';'pass',database.dbo.table)
where id > @.pid
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:680a01c493d3$071362b0$a501280a@.phx.gbl...
> Hi ,
> I have tried to add a linked server(sql2000) residing
> at location B from Location A (a server computer ,using
> SQL 7.0) but i got the error "general network error , pls
> check network documentation" I have gotten the correct
> login id & pwd from the user at the other end.
> have also configured the port#(under Client Utility)
> correctly for client connection and also triedthe
> sp_addlinkedservers & sp_addsvrlogin already
> Is there any dll file needed ? such as DBNET.dll ? to
> add linked server from sql ver 7.0 to sql2000 ?
> Does it need any specific version of the odbc driver
> for SQL Server ? current it's version is 3.70.10.63 i have
> tried to add and odbc link but still have the same error
> I have no problem when using Query Analyzer from my
> client computer AND the user from the other end is able to
> add my sqlserver successfully as a linked server. The odbc
> driver for SQL Server is 3.85.xx.xx
> Appreciate if somebody could help me out as i am doing
> some data migration which i have set up some DTS jobs to
> copy data daily over instead of one big chunks the day
> before migration
> many thks
>|||Hi Uri ,
thks will try out urs
but for my creation script
i have used the Enterprise Manager and just specify the
remote user & pwd
for the query analyzer on the sql server i used :
sp_addlinkedserver 'serverA' -- it's using sql server so
i did not specify the rest of the connection
sp_addsvrlogin 'serverA' ,
false , 'sa', 'userid' , 'userpassword'
for the query analyzer from my local client computer ,
i simply enter the server name , enter the pwd & id and i
get connected
>--Original Message--
>maxzim
>Can you show us your creation script?
>This example works without creating a linked server
>declare @.pid varchar(30)
>set @.pid='2450'
>
>select id from openrowset('sqloledb',
>'server';'sa';'pass',database.dbo.table)
>where id > @.pid
>
>
>
>"maxzsim" <anonymous@.discussions.microsoft.com> wrote in
message
>news:680a01c493d3$071362b0$a501280a@.phx.gbl...
>> Hi ,
>> I have tried to add a linked server(sql2000) residing
>> at location B from Location A (a server computer ,using
>> SQL 7.0) but i got the error "general network error ,
pls
>> check network documentation" I have gotten the correct
>> login id & pwd from the user at the other end.
>> have also configured the port#(under Client Utility)
>> correctly for client connection and also triedthe
>> sp_addlinkedservers & sp_addsvrlogin already
>> Is there any dll file needed ? such as DBNET.dll ? to
>> add linked server from sql ver 7.0 to sql2000 ?
>> Does it need any specific version of the odbc driver
>> for SQL Server ? current it's version is 3.70.10.63 i
have
>> tried to add and odbc link but still have the same error
>> I have no problem when using Query Analyzer from my
>> client computer AND the user from the other end is able
to
>> add my sqlserver successfully as a linked server. The
odbc
>> driver for SQL Server is 3.85.xx.xx
>> Appreciate if somebody could help me out as i am doing
>> some data migration which i have set up some DTS jobs to
>> copy data daily over instead of one big chunks the day
>> before migration
>> many thks
>>
>
>.
>|||Hi
Do you have specified Server Type in the first tab when you use EM?
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:695e01c493d8$fbf0ae50$a301280a@.phx.gbl...
> Hi Uri ,
> thks will try out urs
> but for my creation script
> i have used the Enterprise Manager and just specify the
> remote user & pwd
> for the query analyzer on the sql server i used :
> sp_addlinkedserver 'serverA' -- it's using sql server so
> i did not specify the rest of the connection
> sp_addsvrlogin 'serverA' ,
> false , 'sa', 'userid' , 'userpassword'
> for the query analyzer from my local client computer ,
> i simply enter the server name , enter the pwd & id and i
> get connected
> >--Original Message--
> >maxzim
> >Can you show us your creation script?
> >This example works without creating a linked server
> >declare @.pid varchar(30)
> >set @.pid='2450'
> >
> >
> >select id from openrowset('sqloledb',
> >'server';'sa';'pass',database.dbo.table)
> >where id > @.pid
> >
> >
> >
> >
> >
> >
> >
> >"maxzsim" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:680a01c493d3$071362b0$a501280a@.phx.gbl...
> >> Hi ,
> >>
> >> I have tried to add a linked server(sql2000) residing
> >> at location B from Location A (a server computer ,using
> >> SQL 7.0) but i got the error "general network error ,
> pls
> >> check network documentation" I have gotten the correct
> >> login id & pwd from the user at the other end.
> >>
> >> have also configured the port#(under Client Utility)
> >> correctly for client connection and also triedthe
> >> sp_addlinkedservers & sp_addsvrlogin already
> >>
> >> Is there any dll file needed ? such as DBNET.dll ? to
> >> add linked server from sql ver 7.0 to sql2000 ?
> >>
> >> Does it need any specific version of the odbc driver
> >> for SQL Server ? current it's version is 3.70.10.63 i
> have
> >> tried to add and odbc link but still have the same error
> >>
> >> I have no problem when using Query Analyzer from my
> >> client computer AND the user from the other end is able
> to
> >> add my sqlserver successfully as a linked server. The
> odbc
> >> driver for SQL Server is 3.85.xx.xx
> >>
> >> Appreciate if somebody could help me out as i am doing
> >> some data migration which i have set up some DTS jobs to
> >> copy data daily over instead of one big chunks the day
> >> before migration
> >>
> >> many thks
> >>
> >>
> >
> >
> >.
> >|||Hi Uri ,
i used SQL Server in the 1st tab
>--Original Message--
>Hi
>Do you have specified Server Type in the first tab when
you use EM?
>
>
>"maxzsim" <anonymous@.discussions.microsoft.com> wrote in
message
>news:695e01c493d8$fbf0ae50$a301280a@.phx.gbl...
>> Hi Uri ,
>> thks will try out urs
>> but for my creation script
>> i have used the Enterprise Manager and just specify
the
>> remote user & pwd
>> for the query analyzer on the sql server i used :
>> sp_addlinkedserver 'serverA' -- it's using sql server
so
>> i did not specify the rest of the connection
>> sp_addsvrlogin 'serverA' ,
>> false , 'sa', 'userid' , 'userpassword'
>> for the query analyzer from my local client
computer ,
>> i simply enter the server name , enter the pwd & id and
i
>> get connected
>> >--Original Message--
>> >maxzim
>> >Can you show us your creation script?
>> >This example works without creating a linked server
>> >declare @.pid varchar(30)
>> >set @.pid='2450'
>> >
>> >
>> >select id from openrowset('sqloledb',
>> >'server';'sa';'pass',database.dbo.table)
>> >where id > @.pid
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >"maxzsim" <anonymous@.discussions.microsoft.com> wrote
in
>> message
>> >news:680a01c493d3$071362b0$a501280a@.phx.gbl...
>> >> Hi ,
>> >>
>> >> I have tried to add a linked server(sql2000)
residing
>> >> at location B from Location A (a server
computer ,using
>> >> SQL 7.0) but i got the error "general network error ,
>> pls
>> >> check network documentation" I have gotten the
correct
>> >> login id & pwd from the user at the other end.
>> >>
>> >> have also configured the port#(under Client
Utility)
>> >> correctly for client connection and also triedthe
>> >> sp_addlinkedservers & sp_addsvrlogin already
>> >>
>> >> Is there any dll file needed ? such as
DBNET.dll ? to
>> >> add linked server from sql ver 7.0 to sql2000 ?
>> >>
>> >> Does it need any specific version of the odbc
driver
>> >> for SQL Server ? current it's version is 3.70.10.63 i
>> have
>> >> tried to add and odbc link but still have the same
error
>> >>
>> >> I have no problem when using Query Analyzer from my
>> >> client computer AND the user from the other end is
able
>> to
>> >> add my sqlserver successfully as a linked server. The
>> odbc
>> >> driver for SQL Server is 3.85.xx.xx
>> >>
>> >> Appreciate if somebody could help me out as i am
doing
>> >> some data migration which i have set up some DTS
jobs to
>> >> copy data daily over instead of one big chunks the
day
>> >> before migration
>> >>
>> >> many thks
>> >>
>> >>
>> >
>> >
>> >.
>> >
>
>.
>|||Hi Uri ,
i have used the openrowset but it says "server does not
exist or access denied" which i am using the
administrator's id & pwd
rdgs
>--Original Message--
>Hi
>Do you have specified Server Type in the first tab when
you use EM?
>
>
>"maxzsim" <anonymous@.discussions.microsoft.com> wrote in
message
>news:695e01c493d8$fbf0ae50$a301280a@.phx.gbl...
>> Hi Uri ,
>> thks will try out urs
>> but for my creation script
>> i have used the Enterprise Manager and just specify
the
>> remote user & pwd
>> for the query analyzer on the sql server i used :
>> sp_addlinkedserver 'serverA' -- it's using sql server
so
>> i did not specify the rest of the connection
>> sp_addsvrlogin 'serverA' ,
>> false , 'sa', 'userid' , 'userpassword'
>> for the query analyzer from my local client
computer ,
>> i simply enter the server name , enter the pwd & id and
i
>> get connected
>> >--Original Message--
>> >maxzim
>> >Can you show us your creation script?
>> >This example works without creating a linked server
>> >declare @.pid varchar(30)
>> >set @.pid='2450'
>> >
>> >
>> >select id from openrowset('sqloledb',
>> >'server';'sa';'pass',database.dbo.table)
>> >where id > @.pid
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >"maxzsim" <anonymous@.discussions.microsoft.com> wrote
in
>> message
>> >news:680a01c493d3$071362b0$a501280a@.phx.gbl...
>> >> Hi ,
>> >>
>> >> I have tried to add a linked server(sql2000)
residing
>> >> at location B from Location A (a server
computer ,using
>> >> SQL 7.0) but i got the error "general network error ,
>> pls
>> >> check network documentation" I have gotten the
correct
>> >> login id & pwd from the user at the other end.
>> >>
>> >> have also configured the port#(under Client
Utility)
>> >> correctly for client connection and also triedthe
>> >> sp_addlinkedservers & sp_addsvrlogin already
>> >>
>> >> Is there any dll file needed ? such as
DBNET.dll ? to
>> >> add linked server from sql ver 7.0 to sql2000 ?
>> >>
>> >> Does it need any specific version of the odbc
driver
>> >> for SQL Server ? current it's version is 3.70.10.63 i
>> have
>> >> tried to add and odbc link but still have the same
error
>> >>
>> >> I have no problem when using Query Analyzer from my
>> >> client computer AND the user from the other end is
able
>> to
>> >> add my sqlserver successfully as a linked server. The
>> odbc
>> >> driver for SQL Server is 3.85.xx.xx
>> >>
>> >> Appreciate if somebody could help me out as i am
doing
>> >> some data migration which i have set up some DTS
jobs to
>> >> copy data daily over instead of one big chunks the
day
>> >> before migration
>> >>
>> >> many thks
>> >>
>> >>
>> >
>> >
>> >.
>> >
>
>.
>|||Hi
Probably this is a permission issue. Make sure that you have full
permissions on destination server.
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:673f01c493dc$63f279e0$a601280a@.phx.gbl...
> Hi Uri ,
> i have used the openrowset but it says "server does not
> exist or access denied" which i am using the
> administrator's id & pwd
> rdgs
> >--Original Message--
> >Hi
> >Do you have specified Server Type in the first tab when
> you use EM?
> >
> >
> >
> >
> >"maxzsim" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:695e01c493d8$fbf0ae50$a301280a@.phx.gbl...
> >> Hi Uri ,
> >> thks will try out urs
> >> but for my creation script
> >>
> >> i have used the Enterprise Manager and just specify
> the
> >> remote user & pwd
> >>
> >> for the query analyzer on the sql server i used :
> >>
> >> sp_addlinkedserver 'serverA' -- it's using sql server
> so
> >> i did not specify the rest of the connection
> >>
> >> sp_addsvrlogin 'serverA' ,
> >> false , 'sa', 'userid' , 'userpassword'
> >>
> >> for the query analyzer from my local client
> computer ,
> >> i simply enter the server name , enter the pwd & id and
> i
> >> get connected
> >> >--Original Message--
> >> >maxzim
> >> >Can you show us your creation script?
> >> >This example works without creating a linked server
> >> >declare @.pid varchar(30)
> >> >set @.pid='2450'
> >> >
> >> >
> >> >select id from openrowset('sqloledb',
> >> >'server';'sa';'pass',database.dbo.table)
> >> >where id > @.pid
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >"maxzsim" <anonymous@.discussions.microsoft.com> wrote
> in
> >> message
> >> >news:680a01c493d3$071362b0$a501280a@.phx.gbl...
> >> >> Hi ,
> >> >>
> >> >> I have tried to add a linked server(sql2000)
> residing
> >> >> at location B from Location A (a server
> computer ,using
> >> >> SQL 7.0) but i got the error "general network error ,
> >> pls
> >> >> check network documentation" I have gotten the
> correct
> >> >> login id & pwd from the user at the other end.
> >> >>
> >> >> have also configured the port#(under Client
> Utility)
> >> >> correctly for client connection and also triedthe
> >> >> sp_addlinkedservers & sp_addsvrlogin already
> >> >>
> >> >> Is there any dll file needed ? such as
> DBNET.dll ? to
> >> >> add linked server from sql ver 7.0 to sql2000 ?
> >> >>
> >> >> Does it need any specific version of the odbc
> driver
> >> >> for SQL Server ? current it's version is 3.70.10.63 i
> >> have
> >> >> tried to add and odbc link but still have the same
> error
> >> >>
> >> >> I have no problem when using Query Analyzer from my
> >> >> client computer AND the user from the other end is
> able
> >> to
> >> >> add my sqlserver successfully as a linked server. The
> >> odbc
> >> >> driver for SQL Server is 3.85.xx.xx
> >> >>
> >> >> Appreciate if somebody could help me out as i am
> doing
> >> >> some data migration which i have set up some DTS
> jobs to
> >> >> copy data daily over instead of one big chunks the
> day
> >> >> before migration
> >> >>
> >> >> many thks
> >> >>
> >> >>
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >|||Hi Uri ,
i'll have to check wif the administrator at the other
end then
thks for all the help given =)
>--Original Message--
>Hi
>Probably this is a permission issue. Make sure that you
have full
>permissions on destination server.
>
>"maxzsim" <anonymous@.discussions.microsoft.com> wrote in
message
>news:673f01c493dc$63f279e0$a601280a@.phx.gbl...
>> Hi Uri ,
>> i have used the openrowset but it says "server does not
>> exist or access denied" which i am using the
>> administrator's id & pwd
>> rdgs
>> >--Original Message--
>> >Hi
>> >Do you have specified Server Type in the first tab when
>> you use EM?
>> >
>> >
>> >
>> >
>> >"maxzsim" <anonymous@.discussions.microsoft.com> wrote
in
>> message
>> >news:695e01c493d8$fbf0ae50$a301280a@.phx.gbl...
>> >> Hi Uri ,
>> >> thks will try out urs
>> >> but for my creation script
>> >>
>> >> i have used the Enterprise Manager and just
specify
>> the
>> >> remote user & pwd
>> >>
>> >> for the query analyzer on the sql server i used :
>> >>
>> >> sp_addlinkedserver 'serverA' -- it's using sql
server
>> so
>> >> i did not specify the rest of the connection
>> >>
>> >> sp_addsvrlogin 'serverA' ,
>> >> false , 'sa', 'userid' , 'userpassword'
>> >>
>> >> for the query analyzer from my local client
>> computer ,
>> >> i simply enter the server name , enter the pwd & id
and
>> i
>> >> get connected
>> >> >--Original Message--
>> >> >maxzim
>> >> >Can you show us your creation script?
>> >> >This example works without creating a linked server
>> >> >declare @.pid varchar(30)
>> >> >set @.pid='2450'
>> >> >
>> >> >
>> >> >select id from openrowset('sqloledb',
>> >> >'server';'sa';'pass',database.dbo.table)
>> >> >where id > @.pid
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >"maxzsim" <anonymous@.discussions.microsoft.com>
wrote
>> in
>> >> message
>> >> >news:680a01c493d3$071362b0$a501280a@.phx.gbl...
>> >> >> Hi ,
>> >> >>
>> >> >> I have tried to add a linked server(sql2000)
>> residing
>> >> >> at location B from Location A (a server
>> computer ,using
>> >> >> SQL 7.0) but i got the error "general network
error ,
>> >> pls
>> >> >> check network documentation" I have gotten the
>> correct
>> >> >> login id & pwd from the user at the other end.
>> >> >>
>> >> >> have also configured the port#(under Client
>> Utility)
>> >> >> correctly for client connection and also triedthe
>> >> >> sp_addlinkedservers & sp_addsvrlogin already
>> >> >>
>> >> >> Is there any dll file needed ? such as
>> DBNET.dll ? to
>> >> >> add linked server from sql ver 7.0 to sql2000 ?
>> >> >>
>> >> >> Does it need any specific version of the odbc
>> driver
>> >> >> for SQL Server ? current it's version is
3.70.10.63 i
>> >> have
>> >> >> tried to add and odbc link but still have the same
>> error
>> >> >>
>> >> >> I have no problem when using Query Analyzer
from my
>> >> >> client computer AND the user from the other end is
>> able
>> >> to
>> >> >> add my sqlserver successfully as a linked server.
The
>> >> odbc
>> >> >> driver for SQL Server is 3.85.xx.xx
>> >> >>
>> >> >> Appreciate if somebody could help me out as i am
>> doing
>> >> >> some data migration which i have set up some DTS
>> jobs to
>> >> >> copy data daily over instead of one big chunks the
>> day
>> >> >> before migration
>> >> >>
>> >> >> many thks
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
>
>.
>

Thursday, February 16, 2012

Add a new SQL2000 node

Based on the other threads I've read in the group, I'd like to confirm
the steps needed to perform to add a third node to a cluster that has
been running for a while on 2 nodes...
After adding the new node to the cluster, for each instance in the
cluster (assume: each instance is its own cluster group):
1) Run SQL2000 setup from CD on one of the older nodes; instruct setup
to add the new node as a target for failover.
2) Move the cluster group, making it active on the new node.
3) Install SQL2000 SP4 to the instance from the new node.
Am I missing any steps? Are there additional hotfixes (post-SP4) that
should be installed?
The current (active/active) cluster is running on Win2003 ENT SP1, while
the new node already has Win2003 ENT R2 SP2. The plan is to upgrade the
older hosts to the same rev after the new node is up. Is this workable?
To minimize downtime, you don't have to move any groups to apply SP4.
Rather, from the new node, apply SP4. After that, move the SQL group and
apply the post-SP4 hotfix.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"horseradish" <millardjk@.gmail.com> wrote in message
news:O5L1VrQjHHA.4132@.TK2MSFTNGP05.phx.gbl...
Based on the other threads I've read in the group, I'd like to confirm
the steps needed to perform to add a third node to a cluster that has
been running for a while on 2 nodes...
After adding the new node to the cluster, for each instance in the
cluster (assume: each instance is its own cluster group):
1) Run SQL2000 setup from CD on one of the older nodes; instruct setup
to add the new node as a target for failover.
2) Move the cluster group, making it active on the new node.
3) Install SQL2000 SP4 to the instance from the new node.
Am I missing any steps? Are there additional hotfixes (post-SP4) that
should be installed?
The current (active/active) cluster is running on Win2003 ENT SP1, while
the new node already has Win2003 ENT R2 SP2. The plan is to upgrade the
older hosts to the same rev after the new node is up. Is this workable?
|||There's no need to move the cluster group unless you want to test it will
correctly will startup.
For the SP4. If i Remember well Setup will detect that there's only one node
missing for the SP4 binnaries and will update only that node without
affecting the others.
Hope this helps.
Regards.
FR.
"horseradish" wrote:

> Based on the other threads I've read in the group, I'd like to confirm
> the steps needed to perform to add a third node to a cluster that has
> been running for a while on 2 nodes...
> After adding the new node to the cluster, for each instance in the
> cluster (assume: each instance is its own cluster group):
> 1) Run SQL2000 setup from CD on one of the older nodes; instruct setup
> to add the new node as a target for failover.
> 2) Move the cluster group, making it active on the new node.
> 3) Install SQL2000 SP4 to the instance from the new node.
> Am I missing any steps? Are there additional hotfixes (post-SP4) that
> should be installed?
> The current (active/active) cluster is running on Win2003 ENT SP1, while
> the new node already has Win2003 ENT R2 SP2. The plan is to upgrade the
> older hosts to the same rev after the new node is up. Is this workable?
>
|||Tom Moreau wrote:
> To minimize downtime, you don't have to move any groups to apply SP4.
> Rather, from the new node, apply SP4. After that, move the SQL group and
> apply the post-SP4 hotfix.
>
Based on other things I've seen, it appears that I should be able to add
two nodes (my ultimate plan is to get to 3 nodes using two new and one
current host) to the SQL cluster simultaneously, either when installing
SQL2K RTM _or_ SP4.
Then, once I have my 4-node cluster running, I can uninstall from SQL
and MSCS the one node I wish to remove.
Or will I have to fully install & patch the first new node before I can
repeat with the second?
|||You're probably safer to patch as you go. What if there was a failover in
the middle of what you're doing? It's best to have new nodes like the old
one as soon as you can.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"horseradish" <millardjk@.gmail.com> wrote in message
news:Otdi2JojHHA.4896@.TK2MSFTNGP02.phx.gbl...
Tom Moreau wrote:
> To minimize downtime, you don't have to move any groups to apply SP4.
> Rather, from the new node, apply SP4. After that, move the SQL group and
> apply the post-SP4 hotfix.
>
Based on other things I've seen, it appears that I should be able to add
two nodes (my ultimate plan is to get to 3 nodes using two new and one
current host) to the SQL cluster simultaneously, either when installing
SQL2K RTM _or_ SP4.
Then, once I have my 4-node cluster running, I can uninstall from SQL
and MSCS the one node I wish to remove.
Or will I have to fully install & patch the first new node before I can
repeat with the second?
|||Tom Moreau wrote:
> You're probably safer to patch as you go. What if there was a failover in
> the middle of what you're doing? It's best to have new nodes like the old
> one as soon as you can.
>
Thanks! The safer way is the right way for this implementation...
|||Tom Moreau wrote:
> To minimize downtime, you don't have to move any groups to apply SP4.
> Rather, from the new node, apply SP4. After that, move the SQL group and
> apply the post-SP4 hotfix.
>
Which HF is 'the post-SP4 hotfix'?
|||Check out:
http://aspfaq.com/SQL2000Builds.asp
The hotfix to correct the AWE issue is build 8.00.2040. There have been
subsequent fixes, which are cumulative, so you could apply a later one
instead.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"horseradish" <millardjk@.gmail.com> wrote in message
news:%23rObwnioHHA.4412@.TK2MSFTNGP02.phx.gbl...
Tom Moreau wrote:
> To minimize downtime, you don't have to move any groups to apply SP4.
> Rather, from the new node, apply SP4. After that, move the SQL group and
> apply the post-SP4 hotfix.
>
Which HF is 'the post-SP4 hotfix'?

Thursday, February 9, 2012

Activity on a database?

Hi everyone, I have an SQL2000 with quiet a lot databases and I want to
delete some of them. How do I know if there has been any kind of activity on
a certain database, so I dont delete one that is being used.
Thanks a lot,
Ivan MckenzieTry seting up a trace, but just put in the connections,
then look at the databases connected to.
J
>--Original Message--
>Hi everyone, I have an SQL2000 with quiet a lot
databases and I want to
>delete some of them. How do I know if there has been any
kind of activity on
>a certain database, so I dont delete one that is being
used.
>Thanks a lot,
>Ivan Mckenzie
>
>.
>|||Thanks, I suppose this is done with SQL profiler.
"Julie" <anonymous@.discussions.microsoft.com> escribió en el mensaje
news:2d1d201c469d7$11c0f540$a501280a@.phx.gbl...
> Try seting up a trace, but just put in the connections,
> then look at the databases connected to.
> J
>
> >--Original Message--
> >Hi everyone, I have an SQL2000 with quiet a lot
> databases and I want to
> >delete some of them. How do I know if there has been any
> kind of activity on
> >a certain database, so I dont delete one that is being
> used.
> >
> >Thanks a lot,
> >
> >Ivan Mckenzie
> >
> >
> >.
> >|||Hi,
Run the Profiler for couple of week days . Identify the databases not being
used. Make those databases
offline for minimum 15 days using the below command.
alter database <dbname> set offline
If you are not getting any calls regarding that database, you can backup
those databases , copy to a Tape (or other safe location) and delete the
database.
--
Thanks
Hari
MCDBA
"Ivan Mckenzie" <imck@.inerza.com> wrote in message
news:u6LMgydaEHA.1652@.TK2MSFTNGP09.phx.gbl...
> Thanks, I suppose this is done with SQL profiler.
>
> "Julie" <anonymous@.discussions.microsoft.com> escribió en el mensaje
> news:2d1d201c469d7$11c0f540$a501280a@.phx.gbl...
> >
> > Try seting up a trace, but just put in the connections,
> > then look at the databases connected to.
> >
> > J
> >
> >
> > >--Original Message--
> > >Hi everyone, I have an SQL2000 with quiet a lot
> > databases and I want to
> > >delete some of them. How do I know if there has been any
> > kind of activity on
> > >a certain database, so I dont delete one that is being
> > used.
> > >
> > >Thanks a lot,
> > >
> > >Ivan Mckenzie
> > >
> > >
> > >.
> > >
>|||Thanks a lot.
"Hari Prasad" <hari_prasad_k@.hotmail.com> escribió en el mensaje
news:%23V5N%23SiaEHA.3420@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Run the Profiler for couple of week days . Identify the databases not
being
> used. Make those databases
> offline for minimum 15 days using the below command.
> alter database <dbname> set offline
> If you are not getting any calls regarding that database, you can backup
> those databases , copy to a Tape (or other safe location) and delete the
> database.
> --
> Thanks
> Hari
> MCDBA
> "Ivan Mckenzie" <imck@.inerza.com> wrote in message
> news:u6LMgydaEHA.1652@.TK2MSFTNGP09.phx.gbl...
> > Thanks, I suppose this is done with SQL profiler.
> >
> >
> >
> > "Julie" <anonymous@.discussions.microsoft.com> escribió en el mensaje
> > news:2d1d201c469d7$11c0f540$a501280a@.phx.gbl...
> > >
> > > Try seting up a trace, but just put in the connections,
> > > then look at the databases connected to.
> > >
> > > J
> > >
> > >
> > > >--Original Message--
> > > >Hi everyone, I have an SQL2000 with quiet a lot
> > > databases and I want to
> > > >delete some of them. How do I know if there has been any
> > > kind of activity on
> > > >a certain database, so I dont delete one that is being
> > > used.
> > > >
> > > >Thanks a lot,
> > > >
> > > >Ivan Mckenzie
> > > >
> > > >
> > > >.
> > > >
> >
> >
>

Activity log backup

My company requires a 6 month retention of the archive activity logs for
SQL2000 servers. I need a job that will run each night moving the logs to an
archive file naming the logs to date.logs leaving only the "Current-date
time" log. I have set up the sp-cycle-errorlog to run each night. This
creates a new log in the number sequence.
Any assistance is greatly appreciated. Thanks.
--
JerryHi
You may want to check out http://www.sqldts.com/default.aspx?292
John
"Jerry" wrote:
> My company requires a 6 month retention of the archive activity logs for
> SQL2000 servers. I need a job that will run each night moving the logs to an
> archive file naming the logs to date.logs leaving only the "Current-date
> time" log. I have set up the sp-cycle-errorlog to run each night. This
> creates a new log in the number sequence.
> Any assistance is greatly appreciated. Thanks.
> --
> Jerry

Sunday, March 11, 2012

Add SQL Server 2005 nodes to a SQL2000 cluster

Tuesday, March 6, 2012

add linked server

add linked server

Thursday, February 16, 2012

Add a new SQL2000 node

Thursday, February 9, 2012

Activity on a database?

Activity log backup

Accessing more than

Blog Archive

About Me