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.