SnapProtect - SQL Server iDataAgent - Backup

After configuring your instance and subclient, you are ready to perform your first backup.

Perform a Backup

The following section provides step-by-step instructions to perform your first full backup:

  1. From the CommCell Console, expand Client Computers | <client> | SQL Server | <instance>.
  2. Right-click the <subclient>, and then click Backup.

  3. Select Full as backup type and Immediate to run the job immediately.
  4. Click OK.

    You can track the progress of the job from the Job Controller window of the CommCell console.

    If you are using a stand-alone drive, you are  prompted to load a specific cartridge into the drive. If you are using a library, you will not receive this prompt. The system loads the tapes automatically. Your cartridges should be appropriately labeled. This will enable you to locate the correct cartridge for a restore job, if necessary.

    Once the job is complete, view the details of job from the Backup History.

  5. From the CommCell Console, expand Client Computers | <client> | SQL Server | <instance>.
  6. Right-click the <subclient>, and then select Backup History.

  7. Click OK.

  8. You can view the following details about the job by right-clicking the job:
    • Items that failed during the job
    • Details of the job
    • Media associated with the job
    • Events associated with the job
    • Items included in the job
    • List of backup copy files
    • Log files for the job

    What Gets Backed Up

    • SQL Server system databases, which includes master, msdb, and model
    • SQL Server user databases

    What Does Not Get Backed Up

    • tempdb - as SQL Server re-creates tempdb every time the server is started, it is not included in the backup
    • SQL analysis server database
    • Databases on removable media
    • Databases in single-user mode, suspect, loading, standby, and offline
    • The following cannot be backed up using the SQL Server iDataAgent:
      • Full text indexes
      • SQL Server application files residing on a local hard drive
      • File system data that resides on a SQL Server computer

    Use the File System iDataAgent to back up the above mentioned components.