Restore to a Rebuilt Server | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Restore to a Rebuilt Server

Hi we will shortly be rebuilding one of our servers. Obviously prior to the rebuild we will be taking Full database backups of all users database and system databases. Once the rebuilt server has been re-installed with win2k and SQL2k (I should add that the directory structure will probably remain the same), what is the recommended procedure to restore our SQL server databases and config prior to the server rebuild. There seems to be very little on the full DR scenario (that I can find) so I’ve cobbled together the following from other partial recovery scenarios Firstly Restore the master
  • net stop MSSQLServer Stop SQL Server
  • sqlservr -m Start SQL Server in Single User Mode
  • Go into Enterprise Manager and register the Server using sa Is the sa password empty at the stage after a new SQL install?
  • Select the master database and click all tasks/restore
  • Select add device and then use the file dialogue to locate the file backup of the master prior to server rebuild, check paths and click OK to restore
  • Exit Enterprise Manager
  • net start MSSQLServer Start SQL server in non single user mode
  • Start Enterprise Manager Would the restored master have references to the user databases prior to rebuild and complain that it can’t find them at this point
  • restore MSDB, MODEL and the user databases using all tasks/restore for each one

Firstly are there any glaring ommissions that anyone can see and secondly could anyone answer the questions in bold ? Thanks

Yes as soon as the SQL server is installed you must change SA password and this is mentioned when you’re trying to apply service pack anyway. Refer to thishttp://vyaskn.tripod.com/moving_sql_server.htm link about moving the databases to another server and other corresponding links. Also search in the forums for similar recommendations. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Thanks Satya. That’s a good link – <br /><br />I hadn’t considered just copying my backups back to their respective directories after the server rebuild, Apart from logins and security I’m not entirely sure what else is held in master. Many articles on the web just say that it also contains "server" information, which made me a little nervous of getting the master moved correctly <img src=’/community/emoticons/emotion-5.gif’ alt=’;-)’ /><br /><br />
You need to move system databases if you have many logins and a specific collation for other user databases and MSDB database for DTS packages and scheduled jobs. Follow the notes in books online about restoring master database and then you need msdb and other databases to restore. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Hi, On the rebuilting of master database. After successfully rebuilting it, do we still
need to apply back the service pack fixes again ?
SpongeBob , You may refer following link also.
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=11029
quote:Originally posted by vladimir_sim Hi, On the rebuilting of master database. After successfully rebuilting it, do we still
need to apply back the service pack fixes again ?

No. Luis Martin
Moderator
SQL-Server-Performance.com Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
Leonardo Da Vinci Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte
All postings are provided “AS IS” with no warranties for accuracy.
]]>