SQL Server Performance

FULLTEXT catalogs and BACKUP - behaviour in SQL Server 2005

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Aug 2, 2007.

  1. Anonymous New Member

    There should be no special consideration to perform BACKUP activities within your SQL Server environment. But if you are using FTS with full-text indexes/catalogs then you should be concerned about point-in time recoverability with the backups. You may be aware that from SQL Server 2005 onwardsyou can use the BACKUP and RESTORE statements to back up and restore full-text catalogs in the same way you back up and restore database file data, as the each full-text catalog is treated as a file and is...(<a href="http://sqlserver-qa.net/blogs/tools/archive/2007/08/02/fulltext-catalogs-and-backup-behaviour-in-sql-server-2005.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=1230" width="1" height="1">

Share This Page