FullText Catagory Backup Error

Error:

The backup of full-text catalog 'BTACScotFT' is not permitted because it is not online. Check errorlog file for the reason that full-text catalog became offline and bring it online. Or BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data.
The backup of full-text catalog 'BTAScotFTIndex' is not permitted because it is not online. Check errorlog file for the reason that full-text catalog became offline and bring it online. Or BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data.

 

Failed to enable full-text indexing.

Enable 对于 FullTextIndex“PK__TestFIX__00551192”失败。  (Microsoft.SqlServer.Smo)

全文目录 'TestFIX' 处于不可使用的状态。请删除此全文目录，然后重新创建它。 (Microsoft SQL Server，错误: 7624)

 

Workaround:

 

USE master
declare @DBId as int
declare @DBName as nvarchar(255)
set @DBName='upzone'

select @DBId=database_id from sys.master_files where name=@DBName
SELECT database_id , file_id , type_desc , name , state_desc , physical_name
FROM sys.master_files
WHERE database_id = @DBId

 

....未完待续....