April 14, 2006 at 2:12 pm
OK, here's a tough one. I'm a fairly new DBA and I've lost some stored procedures. I built some emergency database recovery procedures for the Developers to use when I wasn't around. I put them in Master on the production server, created a manual and trained the guys.
Recently I went to update the manual and noticed that the procs are missing without a trace from Master. ( I don't even want to think about what or who is responsible for this) I have lots of backups of all the user databases, but my only chance to find an uncorrupted copy of Master lies in the Veritas backup tapes we archive every week/month.
My question is: How will I open an archived copy of Master. Every instance of SQL Server creates its own set of system databases, so how can I get a backup copy opened so that I can copy the proc's? Can I rename the copy of Master and "fool" it into thinking it is just another user database and attach it to an existing SQL Server?
Thanks for any ideas,
Elliott
April 14, 2006 at 10:19 pm
I did try it for some other reason a couple of weeks ago. I created a new user database named CopyMaster and restored Master backup over it as a database CopyMaster.
Yelena
Regards,Yelena Varsha
April 14, 2006 at 10:57 pm
Yelena, thanks. I'll try that approach next week after I retrieve the backup tapes. I'll post the results.
Elliott
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply