60 pts.
 Building new SQL server
had a sql server (2000 I think) built on enterprise 2003 die. Got new hardware and am beginning the guessing game. any good reference articles, step by step of how to build new and restore backups from external hd. Old server won't even boot.

Software/Hardware used:
ASKED: June 15, 2011  12:56 PM
UPDATED: June 15, 2011  8:08 PM

Answer Wiki:
It's very important that you find out which collation the old SQL server was set in. You'll need to configure to new server to use the same collation so that everything works as expected. After you have this info (you may need to restore a database to another server to see what the collation of the database is set to) you just need to run through the installer. Make sure that the system databases are in the same path as they were before. Then patch to the same build level as the old system, then restore the master database, then the msdb database then the user databases. Don't bother restoring the model database unless you put your own objects in there (which you shouldn't have).
Last Wiki Answer Submitted:  June 15, 2011  8:08 pm  by  ErroneousGiant   3,120 pts.
All Answer Wiki Contributors:  ErroneousGiant   3,120 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _