Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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 stackoverflow.com Dec 16 '09 at 16:55

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

add comment

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

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: dbforums.com/microsoft-sql-server/… –  Jeremy Smyth Dec 17 '09 at 16:55
add comment

backup and restore?

share|improve this answer
add comment

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
add comment

Your Answer

 
discard

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.