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
Development resources, articles, tutorials, code samples, tools and downloads for ASP.Net, SQL Server, Reporting Services, T-SQL, Windows, AWS, SAP HANA and ABAP


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.



SQL Server

SQL Server 2019 Installation
download SQL Server 2019
download SQL Server 2017
download SQL Server 2016
download SQL Server 2014
download SQL Server 2012
MacOS ve SQL Server 2019


Copyright © 2004 - 2021 Eralper YILMAZ. All rights reserved.