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

Restoring Master DB from a StandAlone server to a Cluster Expand / Collapse
Author
Message
Posted Monday, December 9, 2013 3:25 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 11:44 AM
Points: 87, Visits: 1,512
Hi All,

Currently we have a stand alone SQL Server 2008 R2 Ent server. We are planning to move this environment to a Cluster. Once the cluster is ready...the plan is as follows:

1. Copy user databases to the cluster
2. Restore Master and MSDB from stand alone to cluster

My concern is the Server and SQL names. So...the Stand Alone server is called ServerA. When we build the cluster...the name will be ServerB...which we are happy with (not having the same name as the current server). Once I do a restore...we will have the servername = ServerB...but the SQL name
(select @@servername) will be ServerA. I then plan to run the SP_dropserver sp_Addserver to change the SQL name from ServerA to ServerB.

I've done this on a standalone server and it works fine...I just wanted to check if they might be issues with a cluster.
Post #1520983
Posted Monday, December 9, 2013 3:29 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:13 PM
Points: 40,428, Visits: 36,879
I generally recommend not restoring master from one server to another. Script the logins, server-level roles and permissions and linked servers and apply on the new server.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1520985
Posted Monday, December 9, 2013 3:33 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 11:44 AM
Points: 87, Visits: 1,512
Thanks Gail...the reason we are going for this option (restoring) is because there's not much down time. So to ensure as little down time as possible I thought this would be the quickest...but I note your comment.

Thanks again
Post #1520988
Posted Monday, December 9, 2013 3:37 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:13 PM
Points: 40,428, Visits: 36,879
To restore master you need to take the server down, restart it in single user mode, restore then restart again. Running scripts to create logins requires no downtime at all. If you're going for minimal downtime, why are you looking at restoring the backup of master?


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1520991
Posted Monday, December 9, 2013 4:06 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, August 18, 2014 3:04 AM
Points: 1,331, Visits: 15,269
Denesh Naidoo (12/9/2013)
Thanks Gail...the reason we are going for this option (restoring) is because there's not much down time. So to ensure as little down time as possible I thought this would be the quickest...but I note your comment.

Thanks again


Whats preventing you from scripting and applying these in advance?

I always prepare migration servers days (possibly weeks in advance). Consider logshipping databases from the source to the destination too.
Post #1521008
Posted Monday, December 9, 2013 5:01 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:38 PM
Points: 6,635, Visits: 14,218
Denesh Naidoo (12/9/2013)
Hi All,

Currently we have a stand alone SQL Server 2008 R2 Ent server. We are planning to move this environment to a Cluster. Once the cluster is ready...the plan is as follows:

1. Copy user databases to the cluster
2. Restore Master and MSDB from stand alone to cluster

My concern is the Server and SQL names. So...the Stand Alone server is called ServerA. When we build the cluster...the name will be ServerB...which we are happy with (not having the same name as the current server). Once I do a restore...we will have the servername = ServerB...but the SQL name
(select @@servername) will be ServerA. I then plan to run the SP_dropserver sp_Addserver to change the SQL name from ServerA to ServerB.

I've done this on a standalone server and it works fine...I just wanted to check if they might be issues with a cluster.

You cannot perform this, the "IsClustered" option will be set to false in the stand alone system database. You must script out any objects required (you can do most of this in advance) and move them to the new instance. As your service account and computernames will likely change you'll possibly encounter issues with the service master key too, you have been warned


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1521024
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse