Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

migrated from Dec 16 '09 at 16:55

This question came from our site for professional and enthusiast programmers.

up vote 2 down vote accepted

Have you run the Upgrade Advisor? SQL Server 2008 isn't entirely backward compatible with 2000, so there might be some incompatibilities...

share|improve this answer
I did, and it is saying that the Full-Text Search is keeping it from being transfered. I guess its a feature in 2000 and 2005 but not in 2008. – norlando Dec 17 '09 at 14:49
Try this:… – Jeremy Smyth Dec 17 '09 at 16:55

backup and restore?

share|improve this answer

Did you check both the SQL Server logs and the Windows Event Logs?

share|improve this answer
Just the SQL Server logs I'll check the windows event logs. – norlando Dec 16 '09 at 17:42

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.