Page 144 - DCAP508_DATABASE_ADMINISTRATION

Database Administration

Notes 7. Select an existing file or enter a new file name. Click OK after selecting a file.
8. Click the Options tab. The options shown in Figure 10.4 are presented.

Figure 10.4: SQL Server Backup Options

9. Select the Verify backup upon completion check box to verify the backup upon completion.
Description of other fields
Remove inactive entries from transaction log: truncates the transaction log while performing
the backup. If this setting is not checked, SQL Server uses the NO_TRUNCATE option for
the backup. This option is available only while performing transaction log backup.

Check media set name and backup set expiration: verifies the selected media for the provided
media set name to prevent accidental overwrites.
Eject tape after backup: ejects the tape from the drive when the backup completes.

Backup set will expire: specifies when the backup expires and is no longer restorable.
Initialize and label media: erases and labels media sets. Although this option is available for
all tape backups, it is most useful when there are multiple tapes forming a media set.

10. Once all the necessary options are selected, either click the OK button to start performing
the backup, or check the Schedule check box to schedule this operation for periodic execution.
If the backup is performed immediately, the Backup Progress dialog box (Figure 10.5) is
displayed while the backup is being performed.

138 LOVELY PROFESSIONAL UNIVERSITY