HiveBrain v1.2.0
Get Started
← Back to all entries
debugsqlMinor

Unable to BackUp Database on SQL2005

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
databaseunablesql2005backup

Problem

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 error

Solution

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

Context

StackExchange Database Administrators Q#5903, answer score: 4

Revisions (0)

No revisions yet.