SQL Server Performance Forum – Threads Archive

sqlserver migration 2000 to 2005

Hi 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=’

‘ />] thanks in advance regards 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
http://sqlserver-qa.net/blogs/tools…rade-from-previous-version-of-sql-server.aspx
http://sqlserver-qa.net/blogs/tools…-performance-after-an-upgrade-is-so-slow.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.SQL-Server-Performance.Com
@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
http://www.microsoft.com/downloads/…d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en
MohammedU.
Microsoft SQL Server MVP
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>