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

 

....未完待續....