Networks

Ask something
Question Locked

SQL Server Upgrade and Server Move

0 helpful
3 replies

by russ_gunther

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

3 replies

by tony hopkinson

SQL 2000 runs on 2003, then install 2005, run the upgrade wizard. Once it's OK uninstall SQL2000, would be my recomendation..
If the machines have connectivity, you can upgrade a 2000 DB on one server to 2005 on the new one, leaves you a nice clean cut off, a failover and the opprtunity to test the new install.

This discussion is closed to new replies.