Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

SQL Server 2008 R2 not starting after moving model database. Any ideas? Error: 945, Severity: 14, State: 2. Any ideas? Sql 2008 R2 will not start with trace -f -T3608 or single user mode -m. Need params to start SMS to move Model back.

share|improve this question
    
Have you tried moving the model database back using Windows Explorer? –  Max Vernon Mar 5 '13 at 1:11
    
Also, have you checked msdn.microsoft.com/en-us/library/dd207003.aspx which details how to rebuild system databases using SQL Server setup? –  Max Vernon Mar 5 '13 at 1:13
    
I recorded a video demo of how to move the system databases here -- perhaps you can use it to figure out what was missed in your process. –  Jon Seigel Mar 5 '13 at 3:00
add comment

2 Answers 2

You probably moved the model database without issuing the required ALTER DATABASE statements. In the errorlog you will find the path where SQL Server expects to find the model database files (data and log) and you can move back the files to that location and start the service again.

After the service has started, you can follow the instructions given here to move the model database to a different location.

Another possible cause could be the SQL Server service account is unable to access the path where the model database files are stored. Again, you can check it in the errorlog.

share|improve this answer
add comment

model is required to build tempdb. W/o tempdb the server cannot start. Your best action is to move back model to where the engine expects it. Applying TF 3608 (do not recover any database except master) would not help in this situation.

A workaround on how to start the engine in a similar case (Eg. corrupted model) is given at Why does restoring a database needs TempDB?. Alonso uses TF 3609 (Do not recreate tempdb, try to recover it as is) to start up the engine even when model is not present, but it requires tempdb from previous successful run to be in a recoverable state.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.