database 'master' is not valid 9003 error Help!!!

Question

Post reply

database 'master' is not valid 9003 error Help!!!

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

harish_8080 SSC Rookie Points: 39 More actions · Answer 1

Here's my side of story on solving this problem.

I'm using SQL Server 2008 Express Edition on Windows 7

Started SQL Server (SQLEXPRESS) and got error code 3414

After checking on error log, it was showing

The log scan number (19:136: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.

But i do not has backup of model or any database present in the "DATA" folder. There's a really simple solution for this.

Go to "Binn" directory of you MS SQL SERVER.
For me its "C:\Program Files\Microsoft SQL. Server\MSSQL10.SQLEXPRESS\MSSQL\Binn".
In Binn directory, go to the "Templates" folder.
And there is the model, master and msdbdata database mdf and ldf files which was installed with the MS SQL SERVER.
Replace the database file with the corrupted one.

This works for me.

Hope it works for you because it gets 2 hours for me to solve this problem:crazy:

ayanmukherjee Valued Member Points: 61 More actions · Answer 2

Hello harish

Thanks a ton it works perfectly

Thanks

Ayan

puneet_dwivedi SSC Rookie Points: 37 More actions · Answer 3

Hi What do you mean by >> Replace the database file with the corrupted one??

I am having similar issue I can locate the folder and see the files but how to replace them.

Please let me know:-)

Many Thanks

Regards

Puneet

harish_8080 (3/18/2011)
Here's my side of story on solving this problem.
I'm using SQL Server 2008 Express Edition on Windows 7
Started SQL Server (SQLEXPRESS) and got error code 3414
After checking on error log, it was showing
The log scan number (19:136: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.
But i do not has backup of model or any database present in the "DATA" folder. There's a really simple solution for this.
Go to "Binn" directory of you MS SQL SERVER.
For me its "C:\Program Files\Microsoft SQL. Server\MSSQL10.SQLEXPRESS\MSSQL\Binn".
In Binn directory, go to the "Templates" folder.
And there is the model, master and msdbdata database mdf and ldf files which was installed with the MS SQL SERVER.
Replace the database file with the corrupted one.
This works for me.
Hope it works for you because it gets 2 hours for me to solve this problem:crazy:

Andreas AJV SSC Eights! Points: 800 More actions · Answer 4

The expression "Replace the database file with the corrupted one." is wrong.

The correct one must be:

Replace the corrupted ones with the database files in Templates directory.

I have test it and it works.

Thnx

------------
When you 've got a hammer, everything starts to look like a nail...