|
|
|
|
Backing up full text catalog Back
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 edtion , (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.
In some case , you may get error message because the full-text catalog was not online.
To perform a valid backup, SQL Server requires all the database files and full-text catalogs in the database to be online. In this case , you can check the errorlog 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:
http://msdn2.microsoft.com/EN-US/library/bb326385.aspx
http://support.microsoft.com/kb/923355
|
|
|
Home