Master Database Recovery

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Master Database Recovery

Master Database Recovery

Rate Topic

Display Mode

Topic Options

Author

Message

matt.gyton

Posted Tuesday, October 09, 2012 5:27 AM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 9:21 AM
Points: 47, Visits: 146

Hi all,

Is it possible to restore a Master database onto a new server (with identical build) using just copies of the MDF and LDF files from the old server? Or do you need a full backup of the Master?

...and also is it possible to do it this way for the MSDB?

Thanks,

Matt

Post #1370328

Perry Whittle

Posted Tuesday, October 09, 2012 5:31 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 4:05 PM
Points: 5,204, Visits: 11,160

I have, in the past restored a master database to anohter instance as a user database, then detached it and renamed the disk files to their original names and then plugged them into the original instance. I have done this for master model and msdb.

What is the particular problem you ae trying to resolve?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" Wink

Post #1370329

matt.gyton

Posted Tuesday, October 09, 2012 5:41 AM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 9:21 AM
Points: 47, Visits: 146

Hi Perry,

Thanks for that - basically, we have a DR site and our Server Admins have configured WANSync to do regular, block-level copies of all the MDF and LDF files from the live server to a backup server. I was just wondering if these would be sufficient to restore a system database, or whether we would need BAK files instead (we are already creating them, they're just not as easily to hand as the MDF and LDF copies!)

Thanks

Post #1370337

« Prev Topic | Next Topic »

Permissions