December 14, 2009 at 11:16 am
Hello Gurus
We have a backup job that backs up all user databases ever night. one of the databases is not backing up. Below is the error
Executing the query "BACKUP DATABASE [XXXXXXXXXX] TO DISK = N'Y:\\XXXXXXXXXXXXXXXXXXXXXXXXXXXX.bak' WITH NOFORMAT, NOINIT, NAME = XXXXXXXXXXXXXXXXXX, SKIP, REWIND, NOUNLOAD, STATS = 10
" failed with the following error: "The backup of full-text 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.
BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
I have read some MSDN forums and they recommend to drop the full text index and rebuild it. But, we dont have a backup copy of this database (not even in the tapes.) I have no approval to do this directly on the prod box. Can anyne suggest me how to deal with this issue.
Thanks
Ali
December 14, 2009 at 11:24 am
First, you are saying you don't have any good backups of the database?
Second, what is the error(s) that took the full-text index offline?
December 14, 2009 at 11:34 am
Our backup job used to work fine until few months ago. we used have a backup of the DB in tape. Not sure what messed up the Full text index. Now, our two months ago's backup has been purged from the tapes and this job is failing since then. (Don't ask me why we didnt look at this issue since then. I have started here recently.)
Ali
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply