Question

Locked

SQL Server Upgrade and Server Move

By russ_gunther ·
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?

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

I would move the sql 2000 DB to another

by Dumphrey In reply to SQL Server Upgrade and Se ...

sql 2000 server first, no mistake. And would try to have identical patch levels on the SQL 2000 servers.

But Im not a real DBA so I tend to be a little careful and paranoid to not disrupt workflow.

This article walks through going from a 2000 server to a 2005 server straight, looks to be simple and clean.

http://www.aspfree.com/c/a/MS-SQL-Server/Moving-Data-from-SQL-Server-2000-to-SQL-Server-2005/

Hope it helps.

Collapse -

Do one then the other

by Tony Hopkinson In reply to SQL Server Upgrade and Se ...

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.

Back to Networks Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums