May 20, 2003 at 1:43 pm
I am having some trouble restoreing a database through Veritas. It will restore all of the databases except the master data base. The error that I am getting States "RESTORE DATABASE must be in single user mode when trying to restore the master database." I have checked all of my Veritas settings and I can not find any thing out of the ordinary. I have also tried to put the master database into single user mode from the SQL query. The message states that you cannot set the Master data base to single user mode. Does any one have any Ideas or things that I may have forgotten?
May 20, 2003 at 1:48 pm
Sounds like you are restoring every DBs on the server. If that is truely want you want to do, you need to first restore master in single user mode, then restore the rest. Follow these steps:
1) Shutdown SQL Server
2) From the command prompt start SQL Server in single user mode using the following command:
sqlservr.exe -c -m
3) Restore Master. Note: when master restores it will shutdown the single user mode sql server.
4) Start SQL Server normally
5) Restore all the rest of the database.
Hope this helps.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
May 20, 2003 at 2:14 pm
Thankyou that should help alot
quote:
Sounds like you are restoring every DBs on the server. If that is truely want you want to do, you need to first restore master in single user mode, then restore the rest. Follow these steps:1) Shutdown SQL Server
2) From the command prompt start SQL Server in single user mode using the following command:
sqlservr.exe -c -m
3) Restore Master. Note: when master restores it will shutdown the single user mode sql server.
4) Start SQL Server normally
5) Restore all the rest of the database.
Hope this helps.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
May 20, 2003 at 2:14 pm
quote:
Sounds like you are restoring every DBs on the server. If that is truely want you want to do, you need to first restore master in single user mode, then restore the rest. Follow these steps:1) Shutdown SQL Server
2) From the command prompt start SQL Server in single user mode using the following command:
sqlservr.exe -c -m
3) Restore Master. Note: when master restores it will shutdown the single user mode sql server.
4) Start SQL Server normally
5) Restore all the rest of the database.
Hope this helps.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply