Home > Backup and Recovery > Backup Issue if Full text search is enable

Backup Issue if Full text search is enable


SQL Error Message:
The backup of the file or filegroup “sysft_ftcat_documentindex” is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. [SQLSTATE 42000] (Error 3007) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013)

Resolution

workaround:

Initially you need to check the D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\FTData is exist if it is not exist then create the FTData folder

Afterwards:

Run the following query on database.

ALTER FULLTEXT CATALOG ftcat_documentindex REBUILD;

Some useful Full text command:

In the database that uses the full text catalog run:

SELECT name, ftcatid FROM sysobjects WHERE ftcatid > 0

That will give you a list of the tables which use it, then you can mark each table not to use full text:

Advertisements
Categories: Backup and Recovery
  1. September 6, 2014 at 12:25 pm

    I get pleasure from, result in I discovered exactly what I was taking a look
    for. You have ended my four day long hunt!
    God Bless you man. Have a nice day. Bye

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: