I'm trying to transfer a database from SQL server 2000 to SQL Server 2008 using the copy database wizard, but I keep getting an error that tells me to check my error logs. I go check the log and there is nothing on the error. Has anyone had a problem with the copy database wizard and knows a fix for the problem or is there a better method to transfer the database?
migrated from stackoverflow.com Dec 16 '09 at 16:55
Have you run the Upgrade Advisor? SQL Server 2008 isn't entirely backward compatible with 2000, so there might be some incompatibilities...