Home > IT Answers > SQL Server > Migrating SQL Server 2000 to SQL Server 2005
TeachMeIT
975 pts.
 Migrating SQL Server 2000 to SQL Server 2005
Array, SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server migration, SQL Server Upgrade
How can we migrate our sql server 2000 to sql server 2005 on another box? We have about 36 databases and it is around 65 terabytes of data on an external array. The array will be connected to the new server.

Software/Hardware used:
ASKED: October 28, 2010  3:21 PM
UPDATED: January 6, 2011  3:29 PM
RELATED QUESTIONS
Answer Wiki:
All you need to do is detach the databases from the existing server, then attach them to the SQL Server 2005 instance. They will be upgraded automatically when they are attached.
Last Wiki Answer Submitted:  October 29, 2010  4:45 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Would this also apply when going from SQL Server 2000 to SQL Server 2008?

PeteD
 25 pts.