Other SQL Server Blogs around the Web

FULLTEXT catalogs and BACKUP - behaviour in SQL Server 2005

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...(read more)

Read the complete post at http://sqlserver-qa.net/blogs/tools/archive/2007/08/02/fulltext-catalogs-and-backup-behaviour-in-sql-server-2005.aspx

This Blog

Syndication



© 2000 - 2007 vDerivatives Limited All Rights Reserved.