Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 The backup of the file or filegroup "sysft_ftcat_d

Author  Topic 

notDBguru
Starting Member

6 Posts

Posted - 2007-10-26 : 14:57:09
hello,

my full backup job failed and it's giving me the below error message on the backup job for MSCRM database. If I start the job manually if I remove the full-text index on the table, the job ran succesfully.

The backup of the file or filegroup "sysft_ftcat_documentindex" 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)

I appreciate your help in advance!

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-27 : 01:01:55
Ensure file for full text catalog is online when you backup the db.
Go to Top of Page
   

- Advertisement -