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
Comments
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8