Loading...

Microsoft SQL Server

You can use the Commvault software to back up and restore Microsoft SQL Server databases.

Backups

Data You Can Back Up

  • Database
  • Log files

Backups You Can Perform

  • Block-level backups
  • Differential backups
  • Full backups
  • Full backups, using IntelliSnap
  • IntelliSnap backup copy
  • Transaction log backups

When You Can Perform Backups

  • On a schedule: The server plan that you assign manages scheduled backups
  • On demand: You can perform on-demand backups at any time

Restores

Backups You Can Use for Restores

  • The most recent backup: For example, restore the most recent backup to secondary storage, such as tape, for long-term storage
  • A backup from a specific date: For example, restore data to a point in time before it became unusable
  • Backups from a date range: For example, restore data that was accidentally deleted

Destinations You Can Restore To

  • The current location (in place)
  • A different client, instance, or database name
  • A disk

Instant Clones

You can use the cloning feature to create a copy of the database using a full IntelliSnap backup or a block-level backup for a test environment. The system automatically shuts down the clone database and frees up all resources when the reservation period expires.

Automatic Discovery of Applications

You can use the Auto discover applications option to automatically find SQL databases in your environment and install software to back up the SQL databases. For more information, see Automatic Discovery of Applications.

Last modified: 2/17/2021 9:23:04 PM