SQL Express 2005 Unable to Backup database

Symptoms:
Error 3007 The backup of the file or filegroup “sysft_Search” is not permitted because it is not online.

Reason: Imported database from SQL Server 2000 may have reference to full text index, which is not supported by SQL Server Express 2005.

I just arrived at a solution through experimentation. Use at your own risk!

sp_help_fulltext_catalogs
... Gets you the catalog name. In my case it was 'Full Text'

sp_help_fulltext_tables
...Gets you table names which refer to full text indexes
...eg Blobfield

sp_fulltext_table @tabname='BlobField', @action='Drop'
sp_fulltext_catalog @ftcat = 'Full Text', @action='Drop'
... Command(s) completed successfully.

backup database DW30305DEMO to DISK = 'C:DW30305DW30305.dmp'

If you find this post useful, I’d appreciate a link to this URL to assist people in finding the entry quickly. Thanks!

About this entry

You’re currently reading “ SQL Express 2005 Unable to Backup database ,” an entry on Chui's Counterpoint

Published:
11.25.05 / 12am
Category:
SQL Server