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