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

  • 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:

  • Hello harish

    Thanks a ton it works perfectly

    Thanks

    Ayan

  • 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:

  • 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...

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

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