• Perry Whittle (4/4/2013)


    If all the system database files have been wiped out, you cannot start in single user mode as SQL Server expects at least the master database to be present and readable.

    Your best options is:

    • Restore a copy of the master database to a similiar sql server as a user database, call it oldmaster.
    • Detach the database and rename the mdf and ldf to master.mdf and mastlog.ldf
    • Take copies of these files and create

      model.mdf

      modellog.ldf

      msdbdata.mdf

      msdblog.ldf

    • Snap these files into the broken instance and start SQL Server in single user minimal config mode.
    • Restore the master database using the command supplied by Bill.
    • Restore the MDSB and Models too, restart the SQL Server services and you should be good to go.

    Perry,

    Thank you for the suggestion! I have to try it in my lab. "similiar sql server " means same version, right? Also, what else you need to verify after SQL server is online?

    Thanks

    Clare