Hardware failure - rebuilding server

  • 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

  • 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

  • There are a couple of things listed in BOL that you should watch out for as well. Here's the article for master.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply