SQL 2005 Cluster Breakout

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » SQL 2005 Cluster Breakout

SQL 2005 Cluster Breakout

Rate Topic

Display Mode

Topic Options

Author

Message

chris.umpleby

Posted Thursday, January 03, 2013 3:01 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, January 21, 2013 5:45 AM
Points: 2, Visits: 8

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

John Mitchell-245523

Posted Thursday, January 03, 2013 3:36 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 9:05 AM
Points: 4,428, Visits: 7,207

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

chris.umpleby

Posted Thursday, January 03, 2013 3:51 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, January 21, 2013 5:45 AM
Points: 2, Visits: 8

Thanks for the reply, unfortunatley we need to move away from the Cluster setup.

Post #1402274

« Prev Topic | Next Topic »

Permissions