Moving from cluster to un-clustered

FAQ

Profile

Moving from cluster to un-clustered - SQL 2000

Database Forums (Home) -> Clustering

Next: SSIS on cluster

Author

Message

alfamale

External

Since: Dec 19, 2007
Posts: 1

(Msg. 1) Posted: Wed Dec 19, 2007 9:56 am Post subject: Moving from cluster to un-clustered - SQL 2000 Archived from groups: microsoft>public>sqlserver>clustering (more info?)

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! >> Stay informed about: Moving from cluster to un-clustered - SQL 2000

Display posts from previous:

Related Topics:

Moving Non-Clustered to Clustered - Hi, I have been looking for the last few hours for how to move a non-clustered environment to a clustered environment without having to change the connection strings of any of our applications. I'm not finding it anywhere. It's been a while since I....

How to move SQL Server 2005 instance from non-clustered to.. - I have two node cluster (active-pasive) and two instances of SQL server 2005 running on that cluster. Default SQL instance was installed as clustered, the second named instance was not installed as clustered. I want to move named instance form..

Moving from 2000 to a 2005 Cluster - Hey All, We have SQL Server 2000 in our production environment and we have a brand spanking new cluster that has more CPU power and RAM than our current server. The issue I have is how to move the data. We have 10 Databases, most are small, but we have ...

Moving SQl cluster to new SAN... - We have two Microsoft Windows 2000/SQL 2000 clusters that need to move from one SAN to another. The old SAN is going away. Does anyone know of a procedures or white papers on how to accomplish this. -- Dave

Moving sys db in cluster server - Hi, I ran the following script to move the sys logs to diff location in the Active/passive notes cluster server. ALTER DATABASE msdb MODIFY FILE (NAME = msdblog, FILENAME = 'j:\Data\MSSQL.1\MSSQL\Data\msdblog.ldf'); and also for msdblog file Both...

	Database Forums (Home) -> Clustering	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum

Moving from cluster to un-clustered - SQL 2000