February 23, 2012 at 7:08 am
hi...guys
The backup of full-text catalog 'EMGR_Item1_FullText' 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.
reply...thnx
February 23, 2012 at 7:24 am
take a look through your error log as to why the filegroup when offline.
if the error can be fixed, do so and bring the filegroup back online and backup
otherwise change your backup scripts to only backup the online filegroups until you have fixed the full text issue
February 23, 2012 at 7:56 am
When i fire a query of full backup it prompts the error:
The backup of full-text catalog 'EMGR_Item1_FullText' is not permitted because it is not online
The backup of full-text catalog 'KnowledgeBaseCatalog' is not permitted because it is not online
The backup of full-text catalog 'NotesCatalog' is not permitted because it is not online
The backup of full-text catalog 'DocumentsCatalog' is not permitted because it is not online,etc;
when i find these tables under that database i didn't found any table and other tables where present?
reply....
February 23, 2012 at 8:00 am
full text catalogs are not tables, they are usually stored on their own filegroup
so as the error states take a look through your error log to find when the filegroups when offline, it should then tell you in a way, why they went offline. you can then find the error, fix it, bring the filegroups online, and then backup the database
February 23, 2012 at 8:12 am
how to check all these please provide me the link
I went thru this link:
http://support.microsoft.com/kb/923355
reply.......saggy
February 23, 2012 at 8:14 am
that link is good tells you the cause and how to work around it
you need to read the error log, either the SQL error log or the windows error log as SQL logs most errors to both logs for anything which relates to the filegroups going offline
February 23, 2012 at 8:54 am
Source Event ID
Value 3041
Description BACKUP failed to complete the command BACKUP DATABASE Case. Check the backup application log for detailed messages.
reply....thnx
February 23, 2012 at 9:04 am
you need to look further back, find out why the full text catalogs went offline
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply