restore database

[deepji2007]

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)

[bwestover]

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.

[deepji2007]

hi,
i have stoped the SQL server but from where i give the commabd (sqlservr-m)

[bwestover]

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