You are here

Backing up sql server full text catalog

  • For early version of SQL Server (SQL Server 2000 or earlier version) , you have to use special way to back up the full text catalog because it can not be backed up along with database during a normal backup operation .
  • But for a 2005 edition , (including SQL Server 2005 , Express 2005) , you can back up the full text catalog via a database full backup operation , the full text catalog is treated as parts of database files.
  • To perform a valid backup, SQL Server requires all the database files and full-text catalogs in the database to be online.
  • In some case , you may get error message because the full-text catalog was not online. In this case , you can check the error log to find why the catalog became offline and remove this error , then do the backup once again .

For your convenience , following link may be helpful for finding the problem: