Executing an Immediate Backup

You can perform a backup as soon as you define it in the Database Backup/Restore window. There are two ways to execute an immediate backup:

• As a foreground task that occupies SQL Enterprise Manager until the backup completes.
• As a background task that allows SQL Enterprise Manager to remain available to you.

    To execute a backup immediately, as a foreground task

1. Define the backup as described in Backing Up a Database or Transaction Log, earlier in this chapter.
2. From the Database Backup/Restore window, choose the Backup Now button.

   The backup executes. The cursor hourglass is displayed, and SQL Enterprise Manager is unavailable until the backup completes.

    To execute a backup immediately, as a background task

1. Define the backup as described in Backing Up a Database or Transaction Log, earlier in this chapter.
2. From the Database Backup/Restore window, choose the Schedule button.

   The Schedule Backup dialog box appears.

   

3. Select the option for Immediately.
4. Choose the OK button.

   The backup executes, the Database Backup/Restore window returns, and SQL Enterprise Manager is immediately available.