469,930 Members | 1,764 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,930 developers. It's quick & easy.

restore database

hi,
i am facing one problem when i am going to restore backup file. there is one maasage is come (restore detabase must be used in single user mode when trying to restore the master database. restore database is terminating abnormally)
Aug 1 '07 #1
3 1950
hi,
i am facing one problem when i am going to restore backup file. there is one maasage is come (restore detabase must be used in single user mode when trying to restore the master database. restore database is terminating abnormally)
The master database contains information about every other DB in the system.

Therefore in order to overwrite it, it has to be in a special mode where only one string of information could possibly be coming in.

To start SQL Server in single user mode, stop the SQL server and start it again using this command.

sqlservr -m

If this doesnt work, try browsing to the \Microsoft SQL Server\80\Tools\binn directory.

**note overwriting your master database can be very dangerous. Only do this if its completely necessary.
Aug 1 '07 #2
hi,
i have stoped the SQL server but from where i give the commabd (sqlservr-m)
Aug 2 '07 #3
hi,
i have stoped the SQL server but from where i give the commabd (sqlservr-m)
From a command prompt type:

C:\> CD program files\microsoft sql server\80\tools\binn

C:\> sqlservr -m
Aug 2 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Tim Morrison | last post: by
3 posts views Thread by Jon Jacobs | last post: by
4 posts views Thread by Hardy | last post: by
9 posts views Thread by GL | last post: by
11 posts views Thread by Chris | last post: by
5 posts views Thread by chow.justy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.