Hi Folks,
Have any one experienced this kind of error.
The backup of the file or filegroup "sysft_Bug" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. [SQLSTATE 42000] (Error 3007) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013)
please kindly give your suggestions.
warmest
Jayakumar K.
Hi,
I am experiencing the same error but i haven't seen a resoultion or solution to this issue anywhere. Let you know if i find anything.
The backup of the file or filegroup "sysft_FTI_DBTestCatalog" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data.
Cheers
I did a bit of investigating on this issue this mornign and given the events which had transpired i think this is why we may have had this issue...
About an hour prior to the backup, the clustered instance had failed over to the second node. However according to the SQL Log the recovery of all the databases had completed in time. If you run the following query on the affected database you will see that there is a "sysft_FTI" file which is the file for the full-text catalog : "select * from Sys.database_Files". I believe at the time of the backup the status of this file was something other than ONLINE and this was responsible for the backup failure.
On investigation this mornign the sysft_FTI file looked to have an ONLINE status so i performed a full backup and it completed successfully.
Hii...I've same error on migrating sql 2000 to 2005 express...
I'do like this to solve the problem may be usefull - try to deattach db... uncheck keep full text catalogs... - refresh db and attach db again.. and back up will be success..
Regards
This next solution also worked for my sharepoint content database...
1. Go to SharePoint Services Central Administration...
2. Under componant configuration...click on Configure Full-Text Search
3. Uncheck Enable full-text search and index component.
4. Refresh Database...the index should disappear...You can then reenable the full-text search and index component again and you should be good to go...
I like this because I didn't need to take my database off line...
I am having the same issue, and can't get rid of the error with either method.
Error: The backup of the file or filegroup "sysft_TCM_Unfiltered" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data.
But "select * from Sys.database_Files" does not show the file and "select * from sys.fulltext_catalogs" does not show a catalog.
How can I get a backup?
Issue:Can't backup 2005 database after it is restored from a mssql 2000 backup.
Resolution:Here is what worked for me. I upgraded the MSSQL 2005 instance to SP1, then detached (uncheck "Keep Full Text Catalogs" ) and reattached the database. The backup now completes successfully.
I had this issue.
After much brain exercise the fix was simply this:
sp_fulltext_database
Woo hoo
Ian
