SQL Server Upgrade and Server Move

5 pts.
Tags:
Microsoft SQL Server 2000
Microsoft Windows Server 2003
SQL Database
SQL Server 2005
SQL Server upgrades
Windows 2000 Server
I have an old Windows 2000 server running SQL 2000 and need to retire the server and move my SQL databases to a new server. The new server is a fresh install of Windows Server 2003 and SQL Server 2005. I am having a hard time finding a procedure for this complex conversion. Is this something that just isn't done? Should I move the databases onto the new server running SQL 2000 then upgrade to 2005?

Answer Wiki

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

This is an easily done upgrade. It’s basically just as complex as a normal SQL 2000 to SQL 2005 upgrade.

Make sure that all your code is SQL 2005 compliant.

Stop SQL on the SQL 2000 server.
Copy the data files from the SQL 2000 server to the SQL 2005 server.
Attach the files to the SQL 2005 server.
Rename the SQL 2000 server
Rename the SQL 2005 server to match the name of the SQL 2000 server.
sp_dropserver / sp_addserver
Add any jobs, packages etc which need to be added to the server.
Update database statistics for all tables.
Smoke test the system.
Allow the clients to connect again.

The server rename part is optional, but that way you don’t have to change the connection strings on all the client machines.

Discuss This Question: 2  Replies

 
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
  • Denny Cherry
    Check out my SQL Server blog "SQL Server with Mr Denny" for more SQL Server information.
    66,115 pointsBadges:
    report
  • Theitman
    check these out with these steps: 1-http://support.microsoft.com/kb/314546/en-us 2-http://msdn.microsoft.com/en-us/library/ms190436.aspx 3-http://support.microsoft.com/default.aspx?scid=kb;en-us;246133 good luck
    25 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