Building new SQL server

60 pts.
Tags:
Backup
SQL Server
SQL Server 2000
SQL Server 2000 SP4
SQL Server backup and restore
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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).

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • uwantfries
    [...] 3. Mrdenny and ErroneousGiant had some advice for a member who’s building a new SQL Server. [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following