3

I have a database in MS SQL2005 that I can not backup.
Whenever I try to create a backup of the selected database through SQL Mgm studio I get this error:

The Backup of full-text catalog in not permitted because is not online

This database was crated by detaching another database, copying the data and log files, and attaching the copies as a new database. How I can make my full-text catalog be online again. I also tried to set USE FULL TEXT SEARCH to false but without success.

Here is my errorenter image description here

Improve this question

2 Answers 2

Reset to default
4

There is a MS KB article on it which say it happens because

  • The full-text catalog folder is either deleted or corrupted.
  • You did not enable the database for full-text indexing.
  • The database is restored from a Microsoft SQL Server 2000 database backup. Therefore, the folder of the full-text catalog in the database does not exist on the server where you restore the database.
  • The instance of SQL Server 2005 that you are running was upgraded from SQL Server 2000. However, the full-text search service cannot be accessed during the upgrade.
  • The database is attached from somewhere. However, you specify the incorrect location for the full-text catalog folder during the attachment.

The article also has a "workaround" section

Improve this answer
4

When you copied the database and attached did you also copy the full text data to another location, then change the locations of the full text indexes?

It sounds like both of the databases are pointing to the same full text location (or if you copied the database to another server you didn't include the full text data).

Depending on how this is answered will determine the next steps to take.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.