up vote 4 down vote favorite
share [g+] share [fb]

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?

link|improve this question
feedback

migrated from stackoverflow.com Dec 16 '09 at 16:55

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

3 Answers

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...

link|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: dbforums.com/microsoft-sql-server/… – Jeremy Smyth Dec 17 '09 at 16:55
feedback
up vote 0 down vote

backup and restore?

link|improve this answer
feedback
up vote 0 down vote

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

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

Your Answer

 
or
required, but never shown
discard

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