557
Chapter 21: Backup and Recovery Planning
21
FIGURE 21-3
The General page of the Back Up Database form.The backup source is confi gured in the General page:■ (^) Database: The database to be backed up. By default this is the current database in
Management Studio.
■ (^) Backup Type: The type of backup — Full, Differential, or Transaction Log. If the
database is set to the simple recovery model, the transaction log will not be avail-
able. For full or differential backups, the whole database or selected fi les and fi le-
groups can be backed up.
■ (^) Copy Only Backup: Enables you to copy only the backup. This backs up all the data
without breaking the existing backup chain. Although this backup type was fi rst intro-
duced in SQL Server 2005, Management Studio in SQL Server 2005 did not support it.
■ Backup Component: The database component to be backed up — Database or File
and Filegroups. If the backup type selected is Transaction Log, the backup compo-
nent is grayed out. Database indicates that the full database is backed up. File and
Filegroups indicates that the specifi ed fi les and fi legroups are backed up.
c21.indd 557c21.indd 557 7/31/2012 9:22:47 AM7/31/2012 9:22:47 AM
http://www.it-ebooks.info