dbTalk Databases Forums  

Moving from cluster to un-clustered - SQL 2000

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Moving from cluster to un-clustered - SQL 2000 in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
alfamale
 
Posts: n/a

Default Moving from cluster to un-clustered - SQL 2000 - 12-19-2007 , 11:56 AM






From what I'm given to understand, a re-install of SQL Server is required to
return to an un-clustered mode.

We do not plan any other changes: o/s will remain the same as will all
current databases. The server name will be changed to match the current
cluster name prior to re-install. We plan to re-install SQL 2000 Enterprise
and patch it to the same level as it is currently.

To ensure continuity and preserve user accounts, SIDs, permissions & Agent
jobs, can I simply stop SQL Server and replace the system dbs after the first
boot on the new installation? Master & msdb would be the two to replace,
right?

Thanks in advance!

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.