September 22, 2009 at 2:50 pm
I am getting this error message when I try to backup my database.
Msg 3007, Level 16, State 1, Line 1
The backup of the file or filegroup "sysft_Meds_Desc" 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.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
I do not recall creating any filegroups to this db. When I go into the properties of the database, everything looks normal. Can anyone suggest anything to get rid of these file groups? My nightly backups are failing because of this.:crazy:
September 22, 2009 at 3:10 pm
I believe that file is used by full-text search. Has the database been upgraded from SQL 2000 by any chance? To fix it, try rebuilding the full-text catalog.
Greg
September 23, 2009 at 7:22 am
Yes we just upgraded from 2000 to 2005.
September 23, 2009 at 9:55 am
Then I suggest you do the catalog rebuild. We had to do that with full-text catalogs after upgrading.
Greg
September 23, 2009 at 10:26 am
Did you migrate your db by using a backup or did you detach your db?
Thanks for your help.
September 23, 2009 at 10:26 am
Did you migrate your db by using a backup or did you detach your db?
Thanks for your help.
September 23, 2009 at 2:34 pm
We used backup/restore.
Greg
September 23, 2009 at 2:37 pm
What if I just deleted these full index catalogs? I dont think i need them right now? Would I loose any data?
September 24, 2009 at 2:21 pm
No. You'll have to drop the full-text indexes associated with the catalog before you drop the catalog itself. See 'full-text datalogs, removing' in BOL.
You're sure you don't intend to use full-text search in the database?
Greg
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply