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 med by using the filegroup or file clses 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 med by using the filegroup or file clses to restrict the selection to include only online data.
Failed to enable full-text indexing.
Enable fails for fulltextindex "pK _ testfix _ 00551192. (Microsoft. sqlserver. SMO)
The full-text directory 'testfix' is unavailable. Delete the full-text directory and recreate it. (Microsoft SQL Server, error: 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
... To be continued ....