SQL Server 2008 Copy Database Wizard: Fail

sql-server-2008

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.
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 how I can proceed with this will be super helpful

EDIT

The background to this question stemmed from trying to move a database that is in restore/stand by mode (it is the log shipping destination db). This seems to be the only viable channel (not a hack) without breaking the logshipping chain?

Kind Regards
Nai

Best Answer

Rule #1 is that the database copy wizard sucks. It is probably trying to create your stored procedures before it creates the full text indexes. Take a backup of the database and restore it to the other system.