Post reply

DB backup with full-text catalog(help)

  • October 5, 2010 at 9:56 pm

    #140988

    Hi there

    i am using the following script to backup the db but in vain. If there is any other better script could you please send me across.

    BACKUP DATABASE db TO DISK = '\\all\share\db.bak' WITH INIT, NAME = 'db backup'

    Error

    Msg 9987, Level 16, State 1, Line 1

    The backup of full-text catalog 'db_catalog' is not permitted because it is not online. Check errorlog file for the reason that full-text catalog became offline and bring it online. Or BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data.

    Msg 3013, Level 16, State 1, Line 1

    BACKUP DATABASE is terminating abnormally.

    Cheers

  • October 5, 2010 at 11:22 pm

    #1232240

    The BACKUP command is failing because the Full Text Catalog 'db_catalog' is not online. Please navigate to FULL TEXT CATALOGS -> Storage and delete or enable "db_catalog". Try running the backup after this.

    More information here

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply