4

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?

Nick O
  • 195
  • 1
  • 6

3 Answers3

2

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

Jeremy Smyth
  • 718
  • 1
  • 4
  • 6
  • 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. – Nick O Dec 17 '09 at 14:49
  • Try this: http://www.dbforums.com/microsoft-sql-server/1643363-how-uninstall-full-text-search-sql-2000-a.html – Jeremy Smyth Dec 17 '09 at 16:55
0

backup and restore?

mcintyre321
  • 169
  • 1
  • 6
0

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

John Allers
  • 111
  • 3