Microsoft SQL Server
You can use the SQL Server solution to perform backup and restore operations on Microsoft SQL server databases.
To get started, deploy the Commvault SQL Server Agent, and then configure SQL instances.
When you add a SQL Server, you associate a server plan with the server. The Commvault software automatically performs the backup operations by using the schedule and backup operation types that are associated with the plan.
Supported Backup Types
The Commvault SQL Server Agent supports the following backup types from the Command Center:
- Traditional full, differential, and transaction logs
Backups for any client start with a full backup. A full database backup backs up the entire database. A differential backup contains only the data that is new or has changed since the last full backup. A transaction log backup operation backs up the transaction logs that contain records of all the committed and uncommitted transactions.
- IntelliSnap and IntelliSnap backup copy
IntelliSnap backups operations take a snapshot of the database, using hardware array capabilities. You can then archive these snapshots to a secondary storage without the need for traditional backups.
- Block-level backups
Block-level backups integrate snapshot technology with efficient block storage mechanisms to speed up backups.
Supported Restore Types
You can perform any of the following restore operations:
- In-place restore
When you restore a database in place, you restore it to the same path on the same client from which the database was backed up.
The restore operation will overwrite the source data on the database.
- Out-of-place restore
When you restore a database out of place, you can restore it to any one of the following destinations:
- A different client from which the database was backed up
- A different instance from which the database was backed up
- A different database name
- Restore to Disk
You can restore SQL Server data directly to a disk from the Command Center.
This restored data on the disk can be used later to perform database restore using SQL Management studio or any other third party tools.
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: 1/3/2020 4:03:50 PM