October 5, 2010 at 9:56 pm
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
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