asked on Recover Database problem
I am practicing for some scenarios. Lets say my model database gets corrupted. I have renamed the model database model0 for example.
I tried starting the sql database in single user mode from the cmd prompt and it did not work.
1) How to restore the model database from a backup if you don't have the ability to connect to the database through management studio.
i guess that leads me to a couple of questions.
What system databases are required to be optimal for sql server to start in single user mode. I realize i can delete tempdb and it will just recreate it.
i am unsure about model and msdb system databases.
I tried starting the sql database in single user mode from the cmd prompt and it did not work.
1) How to restore the model database from a backup if you don't have the ability to connect to the database through management studio.
i guess that leads me to a couple of questions.
What system databases are required to be optimal for sql server to start in single user mode. I realize i can delete tempdb and it will just recreate it.
i am unsure about model and msdb system databases.
Microsoft SQL Server
Last Comment
Vitor Montalvão
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
That means SQL Server service is stopped.
quick question... when i start sqlservr.exe from the command line with no switches.... I get a red stop symbol beside the sql instance in management studio. Does this mean it is in single-user mode... i am used to seeing single-user mode in text beside the instance
experts-exchange.JPG