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: http://msdn2.microsoft.com/EN-US/library/bb326385.aspx http://support.microsoft.com/kb/923355



Download ms sql server backup and restore software
Download Now
 
More 5 Start Award ....


No risk 30 days money backup guarantee


Download ms sql server backup and restore software
Download Now
 

Copyright @2005-2009 by DataBK.com, all rights reserved.