Sources and destinations for a restore operation

Contributors netapp-soumikd netapp-asubhas Download PDF of this page

You can restore a SQL Server database from a backup copy on either primary or secondary storage. You also can restore the database to different destinations in addition to its original location, enabling you to choose the destination that supports your requirements.

Sources for a restore operation

You can restore databases from primary or secondary storage.

Destinations for a restore operation

You can restore databases to various destinations:

Destination Description

The original location

By default, SnapCenter restores the database to the same location on the same SQL Server instance.

A different location

You can restore the database to a different location on any SQL Server instance within the same host.

Original or different location using different database names

You can restore the database with a different name to any SQL Server instance on the same host where the backup was created.

Note Restore to alternate host across ESX servers for SQL databases on VMDKs (NFS and VMFS datastores) is not supported.