SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software Kodyaz SQL Server Tools Reviews and Tutorials
Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Windows, Windows Phone, SAP and ABAP, like SAP UI5, Screen Personas, etc.




download SQL Server 2016
download SQL Server 2014
download SQL Server 2012



SQL Server Model Database Error 9003

While connecting SQL Server, if you experience "An error has occurred while establishing a connection to the server" error with following error details, SQL Server model database might be corrupted, or the model database log file modellog.ldf does not match the data file model.mdf

Starting up database 'model'.
Error: 9003, Severity: 20, State: 1.
The log scan number (n:n:n) 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.
SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.

SQL Server system model database log file modellog.ldf is corrupted or has inconsistencies. In such a case the model database data file and the log file should be replaced with a healthy mdf and ldf file of the same SQL Server version model datafiles. You can restore model database from previous backups or rebuild the system databases. You can find model database data files in the SQL Server installation media.

SQL Server 2012 model database model.mdf and modellog.ldf file zipped which you can download: SQLServer2012-model-database.zip

SQL Server 2008 RTM Model database data and log file download: SQLServer2008-model-database.zip

Also a friend reported he had experienced SQL Server model database error 9003 right after SQL Server 2008 installation. But we've suspected that the error is caused because on that Windows 7 operating system version, only SQL Server 2008 Service Pack 1 (SP1) was supported. If you face the same SQL model database error, you can try to connect SQL Server 2008 after SP1 setup is also completed.






Related SQL Resources

SQL Server Articles

SQL Server 2016

SQL Server 2014

SQL Server 2012

SQL Server Tools

MS SQL Server Forums









Copyright © 2004 - 2017 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems