July 13, 2009 at 1:26 pm
We had hardware failure on a development database over the weekend. The server group has tried unsuccessfully to get the server running. They are now in the process of rebuilding the server. Once they finish installing the operating system and adding the server back to the domain, I will be reinstalling SQL Server 2005. They have named the server with the same name as the one that died over the weekend. My issue is in gettting all my data restored. I have full backups (which are sufficient for the development system) that I can restore. I don't want to have to rebuild all of my jobs and rebuild the security.
My plan is to install SQL, then restore the master and msdb databases from my backups. Is this correct or am I missing something? I think I need the system dbs restored before trying to restore the user dbs. The good news is that this is not a production environment, so I am treating this as a very good learning experience. The bad news is that the developers need their platform up and running as soon as possible.
Does anyone have suggestions or advice? Am I on the right track or completely wrong?
Thanks for any help!
Kim
July 13, 2009 at 1:35 pm
If there are jobs that are going to start up and expect the user databases to be there, you might get error messages because of that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 13, 2009 at 1:42 pm
There are a couple of things listed in BOL that you should watch out for as well. Here's the article for master.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply