Options

Does Backup include full text indexes?

DephendrDephendr Posts: 2
edited July 28, 2007 11:30AM in SQL Backup Previous Versions
Do the backups (Full, Differential, Transactional) include the full text indexes on the tables? If not, is there an option to include these?

Thanks!
· Share on Twitter

Comments

  • Options
    peteypetey Posts: 2,358 New member
    The type of data that is backed up during a backup process is identical to that performed by SQL Server. For full-text data, this is dependent upon the version of SQL Server you are using. For SQL Server 2000, full-text dat need to be backed up separately from the database backup. For SQL Server 2005, full text data is backed up as part of database backups.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
Sign In or Register to comment.