Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2005 Cluster Breakout Expand / Collapse
Author
Message
Posted Thursday, January 3, 2013 3:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 21, 2013 9:25 AM
Points: 5, Visits: 11
Hi, can anyone please let me know the best procedure to breakout of a SQL 2005 Cluster Setup to an Standalone SQL Server Setup but retain my databases, users and jobs?

Many Thanks

Chris
Post #1402262
Posted Thursday, January 3, 2013 3:36 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:50 AM
Points: 5,367, Visits: 9,913
If you've only got the one instance in your cluster, you could evict nodes until you're left with a single-node cluster. Otherwise, you're probably best building a new instance and moving everything across.

John
Post #1402271
Posted Thursday, January 3, 2013 3:51 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 21, 2013 9:25 AM
Points: 5, Visits: 11
Thanks for the reply, unfortunatley we need to move away from the Cluster setup.
Post #1402274
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse