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.
Sql-server – SQL Server 2008 R2 not starting after moving model database
sql serversql-server-2008-r2system-databases
Related Question
- Sql-server – Moving MSDB database
- Sql-server – SQL Server 2012 Express dying randomly
- SQL Server Model DB – Fix SQL Server Not Starting with Model DB in RESTORING State
- Sql-server – Cluster node upgrade of SQL Server 2008 R2 to SP3 fails when moving resource
- Sql-server – Migrating system and user databases to a new server by moving the LUN
- Sql-server – Suddenly cannot access SQL Server database
- SQL Server 2017 – Cannot Start
Best Answer
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.