SQL Server Performance Forum – Threads Archive
Restore master database for SQL Server 7.0
I am using SQL Server 7.0 on NT Cluster .Is there anything that needs to be done to the cluster before the master database is restored or is it normal restore where cluster does not need to be touched? Rajeev Kumar Srivastava
–ALWAYS BE POSITIVE!–
Restoring master can always be a bit tricky. If it’s a backup of master is from the same cluster then the procedure is the same as with a single server.
I have to restore master backup of other server and other database also.
Can anyone tell me how to restore master database and other database on cluster Environment?
Rajeev Kumar Srivastava
–ALWAYS BE POSITIVE!–
I would not restore a master from another server onto a cluster unless its a new server with same name and config. Move the logins etc with scripts instead.
It is a new server. What is the trick and why we cant restore it normally. Rajeev Kumar Srivastava
–ALWAYS BE POSITIVE!–
I got this information from below link:
Can anybody tell me more about this Tip?
As I am new to SQL Clustering, So I am not sure whether to implement this tip or not?
http://www.sql-server-performance.com/clustering.asp
************************************************************************************* Tip: Don’t restore the master database to a clustered SQL Server unless you have first removed SQL Server clustering. Explanation: SQL Server services, such as the mssqlserver and the sqlserveragent service, should only be started and stopped using the Cluster Administrator. If you don’t follow this rule, it is possible to corrupt your SQL Server cluster. The problem with restoring the master database to a SQL Server cluster is that you have to start SQL Server in Single User Mode from the command line using the -m switch. And once you have restored the master database, SQL Server will automatically (without giving you any opportunity) stop SQL Server. This will result is corruption of your SQL Server cluster. The work-around for this is to first remove SQL Server clustering from servers using the SQL Server 7.0 Cluster Wizard. This of course brings down SQL Server, but there is no way around that. Once SQL Server clustering is removed, you can then restore the master database. Once the master database has been successfully restored, you can then use the SQL Server 7.0 Cluster Wizard to re-install SQL Server Clustering to your cluster. Version: 7.0 *********************************************************************************************
Rajeev Kumar Srivastava
–ALWAYS BE POSITIVE!–
As the tip mentions you need to break the cluster first. I would probably just move over the logins with a script instead. See: HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;246133
]]>