Migrating and consolidating database from SQL Server 2000 into Existing SQL Server 2005

Question

I’d like to know what should I prepare and pay special attention to in migrating and consolidating the SQL Server 2000 database into SQL Server 2005 ? From what I can think of now is that manual Backup and restore is the way to go here.

Any kind of help and suggestion would be greatly appreciated.

Thanks.

Answer 1

I normally use the backup and restore method, set the compatibility level to SQL 2005, and run DBCC UPDATEUSAGE (0);

Answer 2

http://technet.microsoft.com/en-us/library/cc966519.aspx