Getting Started Backup - SQL Server iDataAgent

what gets backed up what does not get backed up
SQL Server system databases, which includes master, msdb, and model

SQL Server user databases

SQL Server Filestream Databases using regular and IntelliSnap Backups

 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.

SQL Server Filestream Databases using VSS

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 Windows File System iDataAgent to back up the above mentioned components.

1.
  • From the CommCell Browser, navigate to Client Computers | <Client> | SQL Server | <Instance>.
  • Right-click the default subclient and click Backup.
2.
  • Click Full as backup type and then click Immediate.
  • Click OK.
3. You can track the progress of the job from the Job Controller window of the CommCell console.
4. Once the job is complete, view the job details from the Backup History. Right-click the Subclient and select Backup History.
5. Click OK.
6. Right-click the job to:
  • Browse the databases that were backed up.
  • View items that failed, if any, during the job.
  • Resubmit the job.
  • View job details.
  • View media associated with the job.
  • View events associated with the job.
  • View backup items (you can view the database files that were backed up e.g., .mdf, .ldf).
  • View or send the log file that is associated with the job.