Microsoft SQL Server

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

Backups

Autodiscovery and Backup

Commvault Cloud automatically discovers and backs up database instances.

Data You Can Back Up

  • Databases

  • Log files

Backups You Can Perform

  • Differential backups

  • Full backups

  • 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 its original location

  • 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

SQL Portability

You can perform the following cross-server restore operations.

Source

Destination

Windows

Linux

Azure SQL

Azure Managed Instance

AWS

Windows

Yes

Yes

Yes, but it must be on the same gateway.

Yes

Yes

Linux

Yes

Yes

Yes

Yes

Yes

Azure SQL

Yes

Yes

Yes

No

No

Azure Managed Instance

No

No

No

Yes

No

AWS

Yes

No

Yes

Yes

Yes

Automatic Discovery of Applications

You can use the Enable auto discover option to automatically find SQL databases in your environment and install software to back up the SQL databases.For more information, see Configuring a SQL Failover Cluster.

Loading...