Friday, October 25, 2013

SQL Service start up problem after SAN splitting

Post SAN Splitting, the SAN drives were available on DR server but SQL service didn't come online.
Below error message was logged in the error log file.
Message: Starting up database 'model'.
Error: 9004, Severity: 21, State: 1.
An error occurred while processing the log for database 'model'.
If possible, restore from backup.
If a backup is not available, it might be necessary to rebuild the log.

Error: 945, Severity: 14, State: 2.
Database 'model' cannot be opened due to inaccessible files or insufficient memory or disk space.
See the SQL Server errorlog for details.
Could not create tempdb. You may not have enough disk space available.
Free additional disk space by deleting other files on the tempdb drive and then restart SQL Server.
Check for additional errors in the event log that may indicate why the tempdb files could not be initialized.

Tried to start the service in single user mode from command prompt, but same error message was logged.
Restored the model db backup file on other server with same physical file names and dettached the database.
Replaced the model database mdf files and ldf files with the dettached model db files. Now started the service and the services came online.