Define a cloning strategy for SQL Server
PDF of this doc site
SnapCenter Server installation
- Configure Certificate-based Authentication
Protect Microsoft SQL Server databases
SnapCenter Plug-in for Microsoft SQL Server
- Prepare to install the SnapCenter Plug-in for Microsoft SQL Server
- SnapCenter Plug-in for Microsoft SQL Server
Protect SAP HANA databases
- SnapCenter Plug-in for SAP HANA Databases
- Prepare to install the SnapCenter Plug-in for SAP HANA Database
- Back up SAP HANA resources
- Protect Oracle databases
- Protect Windows file systems
- Protect Microsoft Exchange Server databases
Protect Custom applications
- Prepare to install SnapCenter Custom Plug-ins
- SnapCenter Server installation
Defining a cloning strategy enables you to clone your database successfully.
Review the limitations related to clone operations.
Decide the type of clone you require.
Limitations of clone operations
You should be aware of the limitations of clone operations before you clone the databases.
If you are using any version of Oracle from 188.8.131.52 to 184.108.40.206, the clone operation will be in hung state when you run the renamedg command. You can apply the Oracle patch 19544733 to fix this issue.
Cloning of databases from a LUN that is directly attached to a host (for instance, by using Microsoft iSCSI Initiator on a Windows host) to a VMDK or an RDM LUN on the same Windows host, or another Windows host, or vice versa, is not supported.
The root directory of the volume mount point cannot be a shared directory.
If you move a LUN that contains a clone to a new volume, the clone cannot be deleted.
Types of clone operations
You can use SnapCenter to clone either a SQL Server database backup or a production database.
Clone from a database backup
The cloned database can serve as a baseline for developing new applications and help isolate application errors that occur in the production environment. The cloned database can also be used for recovery from soft database errors.
You can use SnapCenter to schedule recurring clone jobs that will occur when the production database is not busy.