September 26, 2002 at 9:18 am
I am trying to test a restore of the master database on a failover cluster. To do this I believe I need to be in single user mode. I tried this w/ a '-m' startup parameter and it worked, but I couldn't log in 🙁
My guess is the cluster resources are logging in and preventing me from doing the same.
Anyone have experience restoring the master database on a SQL Server 2000 cluster?
"Keep Your Stick On the Ice" ..Red Green
October 9, 2002 at 7:04 am
For SQL Server 7 on Cluster I have found this link:
http://www.sql-server-performance.com/clustering.asp
and here is the explanation on how to restore master db on cluster:
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.
****
For SQL Server 2K on Cluster I think (I THINK!) that you can set the SQL Server to "DO NOT RESTART" from Cluster Administrator.
Take SQL Server offline.
Start SQL Server in single user mode (-m) switch.
Restore master db.
Set the SQL Server Cluster back to "RESTART" mode.
Bring SQL Server online thru Cluster Administrator.
Hope this help.
Franco
Franco
Franco
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply