September 12, 2011 at 11:06 am
I am new to full text searching so this my be a simple one...
I have ran across an issue when our automated backup process will fail for a Database with the error: "The backup of the file or filegroup 'sysft_FullTextCatalog' is not permitted because it is not online".
What I have done to fix this is drop the catalog and re-create it.
The issue I run in to is I will drop the catalog and when I re-create it it gives me the error: File 'sysft_FullTextCatalog' cannot be reused until after the next BACKUP LOG operation.
I backed up the log and then tried to re-create it and it works. My question is why does it not allow you to re-create the catalog until a log backup is performed?
September 13, 2011 at 8:43 am
There is good explanation in BOL "Backing Up and Restoring Full-Text Catalogs"- hope this can answer your question
September 13, 2011 at 9:00 am
I found a Microsoft article that explains this. Thanks for the help!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply