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.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
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.
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 (