August 24, 2010 at 4:35 am
Hi all
I have Stand alone server(SQL Server 2000) on Win2k3(SP2).
Now I want make as Cluster server.
Please suggest me a best Approch ....
I appreciate you help
August 24, 2010 at 7:47 am
Uninstall SQL. Configure the windows clustering, reinstall SQL as a clustered instance.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 24, 2010 at 8:59 am
Hello Gail Shaw thanks for reply.
You mean
1.Uninstall SQL Server 2000
2.Update Windows 2003 with Cluster (Treat as Node1)
Is it ok..
If I did uninstall SQL Server my data file and log files will in the server or it got delete?.
August 25, 2010 at 4:37 am
Data files will still there be on the drive. But please take the BACKUP of database on SQL Server before uninstalling. As mentioned by Gail, configure Windows Cluster and then install SQL Server on the cluster. Then restore the databases.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply