August 21, 2009 at 7:11 am
how can we restore master datbase apart from command prompt...i tried using commang prompt by typing sqlservr -c -m but it is not working...is there any other method to do this restoration
August 21, 2009 at 7:19 am
shanila_minnu (8/21/2009)
how can we restore master datbase apart from command prompt...i tried using commang prompt by typing sqlservr -c -m but it is not working...is there any other method to do this restoration
You need to shutdown database instance and then restart in single user mode by typing sqlserver -c -m
(for default instance).
Once the database is started in single user mode, you can connect to the instance from query analyzer and then restore the master database from a clean backup.
August 21, 2009 at 7:40 am
Follow instructions from this url.
http://msdn.microsoft.com/en-us/library/aa173515(SQL.80).aspx
SQL DBA.
August 21, 2009 at 8:11 am
after following the task like stopping the server and executing the command ,i tried connecting through query Analyser..but it is throwing the error saying that ,"the server is in single mode..only one user can login"..how can i start the restore now
August 21, 2009 at 8:37 am
how can we go back to multi user mode
August 21, 2009 at 11:58 pm
stop the sq
August 21, 2009 at 11:59 pm
stop the sql server service and restart it.
August 25, 2009 at 4:54 am
i am unable to start the service.it is getting started and then suddenly it will stop
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply