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.
| 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 helpsRegardsShankyhttp://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx |
 |
|
|
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. |
|
|
|
Lincolnburrows
Yak Posting Veteran
52 Posts |
Posted - 2014-09-19 : 02:20:04
|
| HiOne simple way to recover master DB is back up it from any other server and restores it. |
|
|
|
|
|
|
Error: 9003, Severity: 20, State: 1.