Home / server / Questions / 133051
Accepted
Nai
Asked: 2010-04-17 02:48:21 +0800 CST

SQL Server 2008 Copy Database Wizard: Fail

  • 772

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

sql-server-2008

1 Answers

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

    • 2