backup in maint plan failing

Hello, i'm having a problem with a db backup in a maint plan-- i get an
error saying
Msg 3007, Level 16, State 1, Line 2
The backup of the file or filegroup "sysft_ft" 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 2
What is "sysft_ft"? If i search this in google i literally only get one
hit, which is unbelieveable to me. How can I get around this? I really
don't want to do a file backup and would like to get to the bottom of this.
Thanks, NWOP.This looks like an offline full text catalog. If you are using SQL Server
2005 try
select name, state, state_desc from sys.database_files
If one of the names matchs sysft_ft and state_desc is OFFLINE you will need
to fix it first. Perhaps you just need to rebuild the catalog. After the
catalog is ONLINE you will be able to perform your backup.
Hope this helps,
Ben Nevarez
"new_world_order_pigs" wrote:
> Hello, i'm having a problem with a db backup in a maint plan-- i get an
> error saying
> Msg 3007, Level 16, State 1, Line 2
> The backup of the file or filegroup "sysft_ft" 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 2
> What is "sysft_ft"? If i search this in google i literally only get one
> hit, which is unbelieveable to me. How can I get around this? I really
> don't want to do a file backup and would like to get to the bottom of this.
> Thanks, NWOP.|||Ben,
This did seem to work in that it did put the full text cat back "online" so
I'm assuming that when I run the backup in the evening that it should work
just fine. You are officially a "SQL Server Animal" in my book and I
appreciate your help.
Sincerely,
NWOP.
"Ben Nevarez" wrote:
> This looks like an offline full text catalog. If you are using SQL Server
> 2005 try
> select name, state, state_desc from sys.database_files
> If one of the names matchs sysft_ft and state_desc is OFFLINE you will need
> to fix it first. Perhaps you just need to rebuild the catalog. After the
> catalog is ONLINE you will be able to perform your backup.
> Hope this helps,
> Ben Nevarez
>
>
> "new_world_order_pigs" wrote:
> > Hello, i'm having a problem with a db backup in a maint plan-- i get an
> > error saying
> > Msg 3007, Level 16, State 1, Line 2
> > The backup of the file or filegroup "sysft_ft" 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 2
> >
> > What is "sysft_ft"? If i search this in google i literally only get one
> > hit, which is unbelieveable to me. How can I get around this? I really
> > don't want to do a file backup and would like to get to the bottom of this.
> > Thanks, NWOP.