Rebuild SQL Server from scratch. 1

[jballum]

So a client had their database servers physically stolen and need their environments rebuilt. I am pretty sure the backup plan they used will enable me to restore them completely but I was just looking for any heads up or tips to look out for before attempting their rebuild.

{assume NT and SQL installed correclty on new server}

1. Restore Master from backup (following BOL steps for restoring Master).
2. Restore MSDB from backup.
3. Restore all user databases from backups.

Am I being naive in thinking this is it?

Thanks for any help or warnings you can give.

JB

 

[fluteplr]

That should work, you may have problems with Logins not getting set back up properly. Depending on how their security was setup and which version of SQL Server you are working on.

Please post what version of SQL server and I may be able to provide more help.

 

[jnicho02]

fluteplr is right.

SQL Server 6.5 will need you to recreate the devices to the same sizes they were before, plus any expansions to their size must also by reproduced. This can be quite nasty if you have no record of when devices were expanded! My home ---->

http://www.geocities.com/jnicho02/

My company ->

http://www.firstlightassociates.co.uk/

 

[cdukes]

jnicho02 is right,

Hence the need to keep up to date script files of any changes to the structure / objects in your database so that the databases can be completely rebuilt from these script files. Including database devices, logins, users, tables etc.

Chris Dukes

 

[jballum]

They are using SQL Server 7.

I was under the impression that because it is SQL Server 7 then there should be no problem recreating everything if all databases are backed up.

Thanx for you help.

JB