You have to do a fresh install.
There is a possibility to add clustering install a new
virtual server and do a move/copy database from the
current installation to the new one and then remove the
old install. Haven't tried it and there might be some
issues I don't see.
If your issue is numerous clients with references to the
database a fresh install would be the best solution. You
can give the new virtual server the name and IP of your
current server. That might save you a lot of work and
problems.
HTH
Bjorn
[quoted text, click to view] >-----Original Message-----
>We currently have an existing W2K Advance Server running
>SQL 2K EE and are planning on implementing a cluster
using
>the existing server. Anyway to upgrade the existing
>database to a clustered install or do we need to
uninstall
>and reinstall after the OS cluster is established?
>
>Looking for the easy way ;)
>
>Thanks in advance!
>.
Thanks, but my problem is recreating all of the SQL
accounts and having to reset all of the passwords. Can't
use Windows Authentication because of the application.
Any suggestions?
[quoted text, click to view] >-----Original Message-----
>You have to do a fresh install.
>
>There is a possibility to add clustering install a new
>virtual server and do a move/copy database from the
>current installation to the new one and then remove the
>old install. Haven't tried it and there might be some
>issues I don't see.
>
>If your issue is numerous clients with references to the
>database a fresh install would be the best solution. You
>can give the new virtual server the name and IP of your
>current server. That might save you a lot of work and
>problems.
>
>HTH
>
>Bjorn
>>-----Original Message-----
>>We currently have an existing W2K Advance Server running
>>SQL 2K EE and are planning on implementing a cluster
>using
>>the existing server. Anyway to upgrade the existing
>>database to a clustered install or do we need to
>uninstall
>>and reinstall after the OS cluster is established?
>>
>>Looking for the easy way ;)
>>
>>Thanks in advance!
>>.
>>
>.
You can add the shared disk to the cluster. Then follow the steps to move
all your databases (user and system) to that shared disk. Verify everything
is still working. Then do an upgrade. As long as you are using Enterprise
Edition and the data files are all on a shared disk you will have the
option to upgrade to a virtual instance.
314546 HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/?id=314546 BOL topic: How to upgrade from a default instance to a default clustered
instance of SQL Server 2000 (Setup)
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com This posting is provided "AS IS" with no warranties, and confers no rights.
Don't see what you're looking for? Try a search.
