clustered sql server 2005 and 2000 instances sharing the same

clustered sql server 2005 and 2000 instances sharing the same

Post by UGVkam » Sun, 03 Feb 2008 01:16:01


Unfortunatelly no. If there is no other solution, we will have to press
management to buy additional disk space... We also came across some resources
on the net, which claim that it is recommended to install sql server 2000 and
2005 as named instances (both), not as combination of sql server 2000 as
default instance and sql server 2005 as a named instance (no explanation why
there). Do you know anything about that?
 
 
 

clustered sql server 2005 and 2000 instances sharing the same

Post by Tom Morea » Sun, 03 Feb 2008 01:21:52

It just alleviates confusion. It's not carved in stone.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau




Unfortunatelly no. If there is no other solution, we will have to press
management to buy additional disk space... We also came across some
resources
on the net, which claim that it is recommended to install sql server 2000
and
2005 as named instances (both), not as combination of sql server 2000 as
default instance and sql server 2005 as a named instance (no explanation why
there). Do you know anything about that?

 
 
 

clustered sql server 2005 and 2000 instances sharing the same

Post by UGVkam » Sun, 03 Feb 2008 02:04:01

Just to make sure if I understood correctly: so this means that these
instances CANNOT see the same files at any time without copying? Purpose of 2
instances was upgrade to 2005: we wanted to detach sql server 2000 db files,
and to attach them to 2005 (without copying because these are huge files)...
So you're saying that this plan is impossible in clustered environement?

Thanks
 
 
 

clustered sql server 2005 and 2000 instances sharing the same

Post by Tom Morea » Sun, 03 Feb 2008 02:25:23

Typically, the approach I take is to install SQL Server system data on its
own disk, and I keep the application DB's on a separate disk. Then, when I
have to do an upgrade, I install the new instance of SQL, again using a
separate disk for the system DB's. I shut down the old instance, after
first detaching all app DB's. I move the disk resources to the new instance
and set the dependencies. Bring up the new SQL Server and attach the DB's.
Uninstall the old instance and you're there.

Check out:

http://www.yqcomputer.com/

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau




Just to make sure if I understood correctly: so this means that these
instances CANNOT see the same files at any time without copying? Purpose of
2
instances was upgrade to 2005: we wanted to detach sql server 2000 db files,
and to attach them to 2005 (without copying because these are huge files)...
So you're saying that this plan is impossible in clustered environement?

Thanks
 
 
 

clustered sql server 2005 and 2000 instances sharing the same

Post by UGVkam » Sun, 03 Feb 2008 06:28:48

hanks!!!

"Tom Moreau" wrote: