Model Database Corruption:
Model database being one of the crucial database for new database creations and also for Tempdb recreation on every restart.
If model database is corrupt it is going to affect instance functionality.
Steps:
1) Verify if Model is corrupt or not in Eventviewer and SQL Server Error Logs.
2) Confirm if a valid database backup exists or not using restore verifyonly/headeronly.
3) Start instance with Master database Only by enabling the trace 3608.
net start "SQL Server (MSSQLSERVER)" /t3608
4) Restore the Model database from backup.
restore database model from disk=N'F:\Model.bak' WITH REPLACE
5) Start instance normally
net stop "SQL Server (MSSQLSERVER)"
net start "SQL Server (MSSQLSERVER)"
Other Method :
Copy and paste model .mdf,.ndf files from other instance [Required to take instance offline].
For additional details please refer "http://blog.sqlauthority.com/2015/09/26/sql-server-how-to-restore-corrupted-model-database-from-backup/"
Model database being one of the crucial database for new database creations and also for Tempdb recreation on every restart.
If model database is corrupt it is going to affect instance functionality.
Steps:
1) Verify if Model is corrupt or not in Eventviewer and SQL Server Error Logs.
2) Confirm if a valid database backup exists or not using restore verifyonly/headeronly.
3) Start instance with Master database Only by enabling the trace 3608.
net start "SQL Server (MSSQLSERVER)" /t3608
4) Restore the Model database from backup.
restore database model from disk=N'F:\Model.bak' WITH REPLACE
5) Start instance normally
net stop "SQL Server (MSSQLSERVER)"
net start "SQL Server (MSSQLSERVER)"
Other Method :
Copy and paste model .mdf,.ndf files from other instance [Required to take instance offline].
No comments:
Post a Comment