debugsqlMinor
Unable to BackUp Database on SQL2005
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
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 article also has a "workaround" section
- 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.