sqlserver migration 2000 to 2005 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

sqlserver migration 2000 to 2005

Hi<br /><br />Currently we are using sqlserver 2000. but now we have to migrate sqlserver 2000 to sqlserver 2005. i dont know any thing about sql 2005. me just learning.. if u have any document of migration steps.. and some common issues faced while migrating.. can u please send me to this ids. [email protected] [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />thanks in advance<br /><br />regards<br />dhamu
This has been discussed here many times and if you see on this section there is a sticky topic to learn about upgrade tasks to perform. http://sqlserver-qa.net/blogs/tools…-upgrades-of-your-sql-server-environment.aspx
Further don’t forget to go through updated Books online for SQL 2005 on How To topics and also download the upgrade advisor tool. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Don’t forget Books Online…. SQL Server 2005 Books Online
Upgrading to SQL Server 2005
http://technet.microsoft.com/en-us/library/ms144245.aspx And aslo the following… http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx
Microsoft SQL Server MVP
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.