How to restore model database


  • I am doing atest of what happens if model database .dmf and .ldf files are mssing. I tried to do a reapir from installatio CD but it failed that it cannot find model.mdf file... Then waht is the puprose of reparite.

    Since my master database and msdb databases are intact and I have backups of model database; how can bring my sql server 2008 instance up. I have read many article son internet but nothing works. When I try to rebuid master database, it gives some error;

    2013-03-24 02:08:59 Slp:
    2013-03-24 02:08:59 Slp: Error result: -2068643838
    2013-03-24 02:08:59 Slp: Result facility code: 1203
    2013-03-24 02:08:59 Slp: Result error code: 2

    But I should not have rebuild master database because master database and msdb databases are intact. errorlog only shows problem with model database.

    Sunday, March 24, 2013 6:22 AM


All replies