SnapCenter is an enterprise-ready database management product to backup databases swiftly and efficiently and at the same time helps in lowering your TCO. Customers have different types of storage setups, such as databases that could be hosted on physical LUNs or VM virtual disks using any protocol, including ISCSI/FC, SMB, and, most recently, the NVMe-based protocol is gaining traction. Although NVMeoF is not supported directly over a Windows host, in a VMware environment, a VM over an NVMeoF datastore could be set up, and it is supported. SQL Server could run in standalone mode, an Always On failover cluster instance, or an availability group.
Unlike standalone or failover cluster instances where only one copy of the database is available for read/write operations, SQL Server availability group have two or more replicas of the database copy. One replica is used to do read/write operations, and other replicas could be used for read operations, or it could be implemented as standby to meet the high availability business requirement.
One frequent question I encounter is whether SnapCenter can backup databases within an Always On availability group in SQL Server, including the replica copies. Furthermore, how should log backups be configured, and what is the process for performing a restore in this context?
SnapCenter provides multiple ways to backup primary and replica databases. Here is the latest guide on protecting databases in an availability group.
We suggest backing up databases across all the nodes of the availability group, and a detailed description is given in this blog.
https://www.netapp.com/blog/snapcenter-and-sql-server-always-on-availability-groups-why-back-up-databases-from-all-nodes/
For more information about SnapCenter, refer to the SnapCenter documentation.
... View more
Quick and Easy VM Migration, You Say – Tell Me More! Learn about the quick and flexible Shift Toolkit and how it can save you time and money. Learn about the ONTAP features that make this possible.
... View more
Implementation of Oracle VLDB in a Data Guard setting on Google Cloud NetApp Volumes storage service across Google Cloud regions. Snapshot backup and clone the physical standby database to serve use cases such as reporting, dev, test, etc., via automation.
... View more
