January 4, 2005 at 5:58 pm
I am having a problem restoring One of the databases that Great Plains runs on.
I am using a recent backup, and am getting the error:
"Microsoft SQL-DMO (ODBC SQLState: 42000)
RESTORE DATABASE must be used in single user mode when trying to restore the master database.
RESTORE DATABASE is terminating abnormally."
I would appreciate any information that anyone can provide, since I'm pretty well stumped at the moment.
Thanks
January 5, 2005 at 7:45 am
I too am having a problem with single-user mode. Only the opposite of Dan - I can't run my Maintence program for Optimization or integrity checks because the system db needs to be in single user mode.
Is there an easy way to do this thru the Maintenance job?
January 6, 2005 at 8:19 am
Dan,
you have to start SQL in single user mode to restore the master db. Check that it is in fact master that you want to restore. You can check out the following for full information on restoring master http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_4g4w.asp
kjackson,
you could add a step to the job created by the maintenance plan which does an "alter database msdb set single_user" then add a step after the plans completion for "alter database msdb set multi_user"
January 6, 2005 at 8:41 am
Nicholas - Thank you so much -
Dan - Good luck!!
Karen
January 6, 2005 at 11:58 am
Thanks for the advice Nicholas. At the time I wasn't sure how to run Microsoft SQL server in single user mode.
For anyone interested in knowing, you have to run the command 'sqlservr.exe –c –m'
in the Microsoft SQL Server/MSSQL/binn folder through the command prompt.
I was able to restore the master database after this, but it turns out this isn't what i needed to do.
I did get the problem solved tho, so thanks anyways.
Peace.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply