SQL Server 2008 Copy Database Wizard: Fail

Question

I am trying to use the SQL Server 2008 Copy Database Wizard to copy a SQL Server 2008 database. I am using the SQL Management Object method. The database contains a full-text index. I have set the 'Server - Properties - Advanced - Full-Text Upgrade Option' to Reset. However, the copy fails with the following error:

ERROR : 
errorCode=-1073548784 description=Executing the query "/* 
'==============================================..." 
failed with the following error: "Cannot use a CONTAINS or 
FREETEXT predicate on table or indexed view 'Product' because 
it is not full-text indexed."

Any ideas on why this is happening and how I can copy my database would be greatly appreciated.

Kind Regards

Walter

Answer 1

Hi Group,

although I haven't resolved the issue I was having earlier, I have tried and succeeded with an acceptable alternative approach - copy only backup and restore.

Here are some useful references to read:

Copying Databases with Backup and Restore: http://msdn.microsoft.com/en-us/library/ms190436.aspx

Copy Only Backup for SQL Server 2005 and SQL Server 2008: http://www.mssqltips.com/tip.asp?tip=1772

Thanks to all those that stopped by to view and edit / re-format my question.

Kind Regards

Walter