SQL Express 2005 Unable to Backup database

Friday, 25 November 2005

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:\DW30305\DW30305.dmp'

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

The entry 'SQL Express 2005 Unable to Backup database' was posted on November 25th, 2005 at 12:05 am and last modified on July 16th, 2006 at 7:41 pm, and is filed under SQL Server. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

11 Responses to “SQL Express 2005 Unable to Backup database”

  1. Will writes:
    No. 1 — January 31st, 2006 at 9:02 pm

    I owe you big time. Could not for the life of me work out why my backups were failing. (Incidentally - full text was disabled when I backed up the 2000 database but seems to have still been ported over to 2005.)

  2. Mark Byers writes:
    No. 2 — April 13th, 2006 at 4:30 am

    Thanks! Also owe you!

  3. Sébastien writes:
    No. 3 — May 16th, 2006 at 7:40 pm

    Exactly what I search!
    Thanks man,you saved me a lot of time.

  4. Matthew writes:
    No. 4 — July 1st, 2006 at 12:08 am

    Thank you as well. This no doubt saved me hours of trial and error. I’ve already tried almost every sp except the one I needed to drop it from the table itself.

  5. John writes:
    No. 5 — July 13th, 2006 at 2:33 am

    Wow, I was banging my head against the wall all morning. Didn’t even think of full text. Thanks a million for the tip!

  6. Vinh Q Nguyen writes:
    No. 6 — December 8th, 2006 at 4:27 am

    Chui (if that’s your name), you are The Man, The Dude, The Shiz……I was one step short of being institutionalized. Thanks a billion for taking the time to share your gift.

  7. Shawn writes:
    No. 7 — June 7th, 2007 at 5:14 am

    You da man! Thank you from keeping me away from the insane asylum!

  8. Jason writes:
    No. 8 — August 21st, 2007 at 6:38 am

    This totally helped. Thanks so much!

  9. Nathan writes:
    No. 9 — September 3rd, 2007 at 5:32 pm

    Mate, your a legend! Worked a treat.

    Thanks again!

  10. Steve writes:
    No. 10 — January 24th, 2008 at 8:19 pm

    I was pulling my hair out with this issue! You’re a star!

  11. Vishal Shinde writes:
    No. 11 — November 4th, 2008 at 7:05 pm

    Hey dude that was a great one. Hats oFFFFFFFFFFFFFFFF

Leave a Reply

« FTP is not RPC
XCopy deployment of MDF files with ODBC »