Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Error: 9003, Severity: 20, State: 1.

Author  Topic 

trallador
Starting Member

13 Posts

Posted - 2014-09-16 : 03:04:38
Yesterday it was and Storm in my town. Today when I go to job SQL Server cant start the SQL Instance.

Error: 9003, Severity: 20, State: 1....This is the part of log:

2014-09-16 08:11:14.65 Server Database mirroring has been enabled on this instance of SQL Server.
2014-09-16 08:11:14.65 spid5s Starting up database 'master'.
2014-09-16 08:11:14.78 spid5s SQL Trace ID 1 was started by login "sa".
2014-09-16 08:11:14.79 spid5s Starting up database 'mssqlsystemresource'.
2014-09-16 08:11:14.82 spid5s The resource database build version is 9.00.2047. This is an informational message only. No user action is required.
2014-09-16 08:11:14.96 spid8s Starting up database 'model'.
2014-09-16 08:11:14.96 spid5s Server name is 'PQJEM1-PC\SQLEXPRESS'. This is an informational message only. No user action is required.
2014-09-16 08:11:14.96 spid5s Starting up database 'msdb'.
2014-09-16 08:11:15.09 spid8s Error: 9003, Severity: 20, State: 1.
2014-09-16 08:11:15.09 spid8s The log scan number (120:248:1) passed to log scan in database 'model' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.
2014-09-16 08:11:15.09 spid8s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.

Can anyone know a easy way to fix that problem? thanks for advice.

Shanky
Yak Posting Veteran

84 Posts

Posted - 2014-09-16 : 06:53:10
It can be problem with model database or it can be bug. Read this article http://support.microsoft.com/kb/940126/en-gb. I dont think your SQL Server is patched to SP4 is it ?. This is the first thing you should do.If you have backup of model database restore it refer to this link http://msdn.microsoft.com/en-gb/library/ms190190.aspx otherwise you would have to rebuild model database.

Hope this helps

Regards
Shanky
http://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx
Go to Top of Page

trallador
Starting Member

13 Posts

Posted - 2014-09-16 : 14:01:26
Effectively its only SP1.

At the end i waste 3 hours to re-install sql instance and restore backups.

Anyway thanks for the info. will be usefull if someday deals same error.
Go to Top of Page

Lincolnburrows
Yak Posting Veteran

52 Posts

Posted - 2014-09-19 : 02:20:04
Hi

One simple way to recover master DB is back up it from any other server and restores it.

Go to Top of Page
   

- Advertisement -