2005 backup woes

[katgirl]

SQL Server 2005 - backing up to a network share

Has anyone seen this error message when performing a backup?

The backup of the file or filegroup "sysft_Articles" is not permitted because it is not online.

There is a table in this database called "Articles". I can query from the table, but when I right-click on the table name in management studio, I get another error:

"Specified cast is not valid"

???

 

[mrdenny]

It's because you have a full text index on the database. I was getting this every once and a while. So I setup a first step of the backup job that checks the status of all the file groups. If they are all online the backup runs. I haven't had any problems since then.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[katgirl]

yes, i found that by running:

sp_fulltext_database enable

that i was able to get my backups working, although not 100% sure what this is doing

i now see that i have full text enabled on all my databases

it's just a test machine so i wasn't too concerned