Request doc changes
Edit this page
Learn how to contributeDefine a restoration strategy for SQL Server
Contributors
Defining a restoration strategy for SQL Server enables you to restore your database successfully.
-
PDF of this doc site
-
Protect Microsoft SQL Server databases
-
Protect SAP HANA databases
-
Collection of separate PDF docs
Creating your file...
This may take a few minutes. Thanks for your patience.
Your file is ready
- SnapCenter Software 4.6 docs
- Release notes
-
Concepts
-
SnapCenter Server installation
- Installation workflow
-
Prepare for installing the SnapCenter Server
- Install the SnapCenter Server
- Log in to SnapCenter
-
Configure CA Certificate
-
Configure Active Directory, LDAP, and LDAPS
-
Configure High Availability
-
Configure role-based access control (RBAC)
- Add storage systems
- Add SnapCenter Standard controller-based licenses
- Add SnapCenter Standard capacity-based licenses
-
Provision your storage system
- Configure secured MySQL connections with SnapCenter Server
- Features enabled on your Windows host during installation
-
Protect Microsoft SQL Server databases
-
SnapCenter Plug-in for Microsoft SQL Server
- SnapCenter Plug-in for Microsoft SQL Server overview
- What you can do with the SnapCenter Plug-in for Microsoft SQL Server
- SnapCenter Plug-in for Microsoft SQL Server features
- Support for Asymmetric LUN Mapping in Windows clusters
- Storage types supported by SnapCenter Plug-ins for Microsoft Windows and for Microsoft SQL Server
- Storage layout recommendations for SnapCenter Plug-in for Microsoft SQL Server
- Minimum ONTAP privileges required for SQL plug-in
- Prepare storage systems for SnapMirror and SnapVault replication
-
Backup strategy for SQL Server resources
- Define a backup strategy for SQL Server resources
- Type of backups supported
- Backup schedules for database plug-ins
- Number of backup jobs needed for databases
- Backup naming conventions
- Backup retention options
- How long to retain transaction log backups on the source storage system
- Multiple databases on the same volume
- Backup copy verification using the primary or secondary storage volume
- When to schedule verification jobs
-
Restoration strategy for SQL Server
- Define a cloning strategy for SQL Server
- Quick start to install SnapCenter Plug-in for Microsoft SQL Server
-
Prepare to install the SnapCenter Plug-in for Microsoft SQL Server
- Installation workflow for SnapCenter Plug-in for Microsoft SQL Server
- Prerequisites to add hosts and install SnapCenter Plug-in for Microsoft SQL Server
- Host requirements to install SnapCenter Plug-ins Package for Windows
- Set up credentials for the SnapCenter Plug-ins Package for Windows
- Configure credentials for an individual SQL Server resource
- Configure gMSA on Windows Server 2012 or later
-
Install SnapCenter Plug-in for Microsoft SQL Server
- Add hosts and install the SnapCenter Plug-ins Package for Windows
- Install SnapCenter Plug-in for Microsoft SQL Server on multiple remote hosts by using cmdlets
- Install the SnapCenter Plug-in for Microsoft SQL Server silently from the command line
- Monitor the status of installing Plug-in for SQL Server
-
Configure CA Certificate
-
Configure Disaster recovery
-
Import archived backups from SnapManager for Microsoft SQL Server to SnapCenter
- Install SnapCenter Plug-in for VMware vSphere
-
Prepare for data protection
-
Back up SQL Server database, or instance, or availability group
- Backup workflow
- Determine whether resources are available for backup
- Migrate resources to NetApp storage system
- Create backup policies for SQL Server databases
- Create resource groups and attach policies for SQL Server
- Requirements for backing up SQL resources
- Back up SQL resources
- Back up SQL Server resource groups
-
Monitor backup operations
- Create a storage system connection and a credential using PowerShell cmdlets
- Back up resources using PowerShell cmdlets
- Cancel the SnapCenter Plug-in for Microsoft SQL Server backup operations
- View SQL Server backups and clones in the Topology page
- Remove backups using PowerShell cmdlets
- Clean up the secondary backup count using PowerShell cmdlets
-
Restore SQL Server resources
-
Clone SQL Server database resources
-
-
Protect SAP HANA databases
-
SnapCenter Plug-in for SAP HANA Databases
- SnapCenter Plug-in for SAP HANA Database overview
- What you can do using the SnapCenter Plug-in for SAP HANA Database
- SnapCenter Plug-in for SAP HANA Database features
- Storage types supported by SnapCenter Plug-in for SAP HANA Database
- Minimum ONTAP privileges required
- Prepare storage systems for SnapMirror and SnapVault replication
-
Backup strategy for SAP HANA databases
- Define a backup strategy for SAP HANA databases
- Automatic discovery of resources on Linux host
- Type of backups supported
- How SnapCenter Plug-in for SAP HANA Database uses consistency group Snapshot copies
- How SnapCenter manages housekeeping of log and data backups
- Considerations for determining backup schedules for SAP HANA database
- Number of backup jobs needed for SAP HANA databases
- Backup naming conventions
-
Restore and recovery strategy for SAP HANA databases
- Define a restore and recovery strategy for SAP HANA resources
- Types of restore strategies supported for manually added SAP HANA resources
- Types of restore strategies supported for automatically discovered SAP HANA databases
- Types of restore operations for auto discovered SAP HANA databases
- Types of recovery operations supported for SAP HANA databases
-
Prepare to install the SnapCenter Plug-in for SAP HANA Database
- Installation workflow of SnapCenter Plug-in for SAP HANA Database
- Prerequisites for adding hosts and installing SnapCenter Plug-in for SAP HANA Database
- Host requirements to install SnapCenter Plug-ins Package for Windows
- Host requirements for installing the SnapCenter Plug-ins Package for Linux
- Set up credentials for the SnapCenter Plug-in for SAP HANA Database
- Configure gMSA on Windows Server 2012 or later
-
Install the SnapCenter Plug-in for SAP HANA Databases
- Add hosts and install plug-in packages on remote hosts
- Install SnapCenter Plug-in Packages for Linux or Windows on multiple remote hosts by using cmdlets
- Install the SnapCenter Plug-in for SAP HANA Database on Linux hosts by using the command-line interface
- Monitor SnapCenter plug-in package installation status
-
Configure CA Certificate
- Generate CA Certificate CSR file
- Import CA certificates
- Get the CA certificate thumbprint
- Configure CA certificate with Windows host plug-in services
- Configure the CA Certificate for the SnapCenter SAP HANA Plug-ins service on Linux host
- Configure the CA Certificate for the SnapCenter SAP HANA Plug-ins service on Windows host
- Enable CA Certificates for plug-ins
- Install SnapCenter Plug-in for VMware vSphere
-
Prepare for data protection
-
Back up SAP HANA resources
- Back up workflow
- Configure HDB User Store Key and HDBSQL OS User for the SAP HANA database
-
Discover resources and prepare multitenant database containers for data protection
- Add resources manually to the plug-in host
- Create backup policies for SAP HANA databases
- Create resource groups and attach policies
- Back up SAP HANA databases
- Back up resource groups
- Create a storage system connection and a credential using PowerShell cmdlets for SAP HANA database
- Back up databases using PowerShell cmdlets
-
Monitor backup operations
- Cancel the backup operations
- View SAP HANA database backups and clones in the Topology page
-
Restore SAP HANA Databases
-
Clone SAP HANA resource backups
-
-
Protect Oracle databases
-
Overview of SnapCenter Plug-in for Oracle Database
-
Install SnapCenter Plug-in for Oracle Database
- Installation workflow of SnapCenter Plug-in for Oracle Database
- Prerequisites for adding hosts and installing Plug-ins Package for Linux or AIX
- Add hosts and install Plug-ins Package for Linux or AIX
- Alternate ways to install Plug-ins Package for Linux or AIX
- Configure the SnapCenter Plug-in Loader service
- Configure CA certificate with SnapCenter Plug-in Loader service on Linux host
- Enable CA Certificates for plug-ins
- Import data from SnapManager for Oracle and SnapManager for SAP to SnapCenter
- Install SnapCenter Plug-in for VMware vSphere
- Prepare for protecting Oracle databases
-
Back up Oracle databases
- Backup workflow
- Define a backup strategy for Oracle databases
- Predefined environment variables for backup specific prescript and postscript
- Determine whether Oracle databases are available for backup
- Create backup policies for Oracle databases
- Create resource groups and attach policies for Oracle databases
- Requirements for backing up an Oracle database
- Back up Oracle resources
- Back up Oracle database resource groups
- Back up Oracle databases using UNIX commands
- Monitor Oracle database backup operations
- Cancel backup operations of Oracle databases
- View Oracle database backups and clones in the Topology page
- Mount and unmount database backups
-
Restore and recover Oracle databases
- Restore workflow
- Define a restore and recovery strategy for Oracle databases
- Predefined environment variables for restore specific prescript and postscript
- Requirements for restoring an Oracle database
- Restore and recover Oracle database
- Restore and recover tablespaces using point-in-time recovery
- Restore and recover pluggable database using point-in-time recovery
- Restore and recover Oracle databases using UNIX commands
- Monitor Oracle database restore operations
- Cancel Oracle database restore operations
-
Clone Oracle database
- Clone workflow
- Define a clone strategy for Oracle databases
- Predefined environment variables for clone specific prescript and postscript
- Requirements for cloning an Oracle database
- Clone an Oracle database
- Clone a pluggable database
- Clone Oracle database backups using UNIX commands
- Split an Oracle Database Clone
- Split clone of a pluggable database
- Monitor Oracle database clone operations
- Refresh a clone
- Delete clone of a pluggable database
-
Manage application volumes
-
-
Protect Windows file systems
-
SnapCenter Plug-in for Microsoft Windows concepts
- SnapCenter Plug-in for Microsoft Windows overview
- What you can do with the SnapCenter Plug-in for Microsoft Windows
- SnapCenter Plug-in for Windows features
- How SnapCenter backs up Windows file systems
- Storage types supported by SnapCenter Plug-ins for Microsoft Windows
- Minimum ONTAP privileges required for Windows plug-in
- Prepare storage systems for SnapMirror and SnapVault replication
- Define a backup strategy for Windows file systems
- Sources and destinations of clones for Windows file systems
-
Install SnapCenter Plug-in for Microsoft Windows
- Installation workflow of SnapCenter Plug-in for Microsoft Windows
- Installation requirements for SnapCenter Plug-in for Microsoft Windows
- Configure gMSA on Windows Server 2012 or later
- Add hosts and install SnapCenter Plug-in for Microsoft Windows
- Install SnapCenter Plug-in for Microsoft Windows on multiple remote hosts using PowerShell cmdlets
- Install the SnapCenter Plug-in for Microsoft Windows silently from the command line
- Monitor SnapCenter plug-in package installation status
-
Configure CA certificate
- Install SnapCenter Plug-in for VMware vSphere
-
Back up Windows file systems
- Backup workflow
- Determine resource availability for Windows file systems
- Create backup policies for Windows file systems
- Create resource groups for Windows file systems
- Back up a single resource on demand for Windows file systems
- Back up resource groups for Windows file systems
- Create a storage system connection and a credential using PowerShell cmdlets
- Back up resources using PowerShell cmdlets
- Monitor backup operations
- Cancel the backup operations
- View related backups and clones in the Topology page
- Remove backups using PowerShell cmdlets
- Clean up the secondary backup count using PowerShell cmdlets
-
Restore Windows file systems
-
Clone Windows file systems
-
-
Protect Microsoft Exchange Server databases
-
SnapCenter Plug-in for Microsoft Exchange Server concepts
- Overview
- What you can do with SnapCenter Plug-in for Microsoft Exchange Server
- Storage types supported by SnapCenter Plug-in for Microsoft Windows and for Microsoft Exchange Server
- Minimum ONTAP privileges required
- Prepare storage systems for SnapMirror and SnapVault replication
- Define a backup strategy for Exchange Server resources
- Define a restore strategy for Exchange databases
-
Install SnapCenter Plug-in for Microsoft Exchange Server
- Installation workflow of SnapCenter Plug-in for Microsoft Exchange Server
- Prerequisites to add hosts and install SnapCenter Plug-in for Microsoft Exchange Server
- Set up credentials for SnapCenter Plug-in for Windows
- Configure gMSA on Windows Server 2012 or later
- Add hosts and install Plug-in for Exchange
- Install Plug-in for Exchange from the SnapCenter Server host using PowerShell cmdlets
- Install the SnapCenter Plug-in for Exchange silently from the command line
- Monitor SnapCenter plug-in package installation status
-
Configure CA Certificate
- Configure SnapManager 7.x for Exchange and SnapCenter to coexist
- Install SnapCenter Plug-in for VMware vSphere
- Prepare for data protection
-
Back up Exchange resources
- Backup workflow
- Exchange database and backup verification
- Determine whether Exchange resources are available for backup
- Create backup policies for Exchange Server databases
- Create resource groups and attach policies for Exchange Servers
- Back up Exchange databases
- Back up Exchange resources groups
- Create a storage system connection and a credential using PowerShell cmdlets for Exchange Server
- Back up Exchange resources using PowerShell cmdlets
- Monitor backup operations
- Cancel backup operations for Exchange database
- Remove Exchange backups using PowerShell cmdlets
- View Exchange backups in the Topology page
-
Restore Exchange resources
- Restore workflow
- Requirements for restoring an Exchange database
- Restore Exchange databases
- Granular recovery of mails and mailbox
- Restore an Exchange Server database from secondary storage
- Restore Exchange resources using PowerShell cmdlets
- Reseed a passive Exchange node replica
- Reseed a replica using PowerShell cmdlets for Exchange database
- Monitor restore operations
- Cancel restore operations
-
-
Protect Custom applications
-
SnapCenter Custom Plug-ins
- SnapCenter Custom Plug-ins overview
- What you can do with the SnapCenter Custom Plug-ins
- SnapCenter Custom Plug-ins features
- Storage types supported by SnapCenter Custom Plug-ins
- Minimum ONTAP privileges required for custom plug-in
- Prepare storage systems for SnapMirror and SnapVault replication
- Define a backup strategy
-
Backup strategy for custom plug-ins
- Types of restore strategies supported for manually added custom plug-in resources
-
Develop a plug-in for your application
-
Prepare to install SnapCenter Custom Plug-ins
- Installation workflow of SnapCenter Custom Plug-ins
- Prerequisites for adding hosts and installing SnapCenter Custom Plug-ins
- Host requirements to install SnapCenter Plug-ins Package for Windows
- Host requirements for installing the SnapCenter Plug-ins Package for Linux
- Set up credentials for SnapCenter Custom Plug-ins
- Configure gMSA on Windows Server 2012 or later
-
Install the SnapCenter Custom Plug-ins
-
Configure CA Certificate
- Generate CA Certificate CSR file
- Import CA certificates
- Get the CA certificate thumbprint
- Configure CA certificate with Windows host plug-in services
- Configure the CA Certificate for the SnapCenter Custom Plug-ins service on Linux host
- Configure the CA Certificate for the SnapCenter Custom Plug-ins service on Windows host
- Enable CA Certificates for plug-ins
-
Prepare for data protection
-
Back up custom plug-in resources
- Back up workflow
- Add resources to SnapCenter Custom Plug-ins
- Create policies for custom plug-in resources
- Create resource groups and attach policies
- Back up individual custom plug-in resources
- Back up resource groups of custom plug-in resources
- Create a storage system connection and a credential using PowerShell cmdlets
- Back up resources using PowerShell cmdlets
- Monitor backup operations
- Cancel the backup operations
- View custom plug-in resource related backups and clones in the Topology page
-
Restore custom plug-in resources
-
Clone custom plug-in resource backups
-
-
Manage SnapCenter Server and plug-ins
-
View dashboard
- Manage RBAC
- Manage hosts
- Operations supported from the Resources page
- Manage policies
- Manage resource groups
- Manage backups
- Delete clones
- Monitor jobs, schedules, events, and logs
- Overview of SnapCenter reporting capabilities
- Manage the SnapCenter Server repository
- Manage resources of untrusted domains
- Manage the storage system
- Manage EMS data collection
-
-
Upgrade SnapCenter Server and plug-ins
-
Uninstall SnapCenter Server and plug-ins
-
Automate using REST APIs
- Overview of REST APIs
- How to access SnapCenter REST API natively
- REST web services foundation
- Basic operational characteristics
- Input variables controlling an API request
- Interpretation of an API response
-
Supported REST APIs
- How to access REST APIs using the Swagger API web page
- Get started with the REST API
- Legal notices