Issue 1:

Database 'model' cannot be opened. It is in the middle of a restore.
below is the error information from SQL error logs
2016-06-28 002039.02 spid7s      Starting up database 'model'.
2016-06-28 002040.01 spid7s      The database 'model' is marked RESTORING and is in a state that does not allow recovery to be run.
2016-06-28 002040.04 spid7s      Error 927, Severity 14, State 2.
2016-06-28 002040.04 spid7s      Database 'model' cannot be opened. It is in the middle of a restore.
Best references for fix:

http://blog.sqlauthority.com/2014/11/25/sql-server-fix-the-database-model-is-marked-restoring-and-is-in-a-state-that-does-not-allow-recovery-to-be-run/

Issue 2:

Model is corrupted hence SQL Service is not starting 
below is the error information from SQL error logs

2016-06-28 13:55:28.39 spid11s     Srating up database ‘model’.

2016-06-28 13:55:28.49 spid11s    Error: 5125, Severity: 24, State: 2.

Best reference for fix:

http://blog.sqlauthority.com/2015/09/26/sql-server-how-to-restore-corrupted-model-database-from-backup/

Advertisements