SQL Server related information:
Do not use NMM VSS technology and NMM VDI technology together to back up and recover a SQL Server.
NMM VSS technology VS NMM VDI (hardware, operating system, service pack, and application versions supported):
|NMM VSS||NMM VDI|
|Windows Server versions are supported||◆ Windows Server 2012 R2 (x64)
◆ Windows Server 2012 (x64)
◆ Windows Server 2008 R2 SP1 (x64)
◆ Windows Server 2008 SP2 (x86, x64)
|◆ Windows Server 2012 R2
◆ Windows Server 2012
◆ Windows Server 2008 R2 SP1
◆ Windows Server 2008 SP2
◆ Windows Server 2003 SP2
|SQL Server versions are supported||Standard, Enterprise, Express, Datacenter, Web, Workgroup, Developer editions||Standard, Enterprise, Express, Datacenter, Web, Workgroup, Developer editions|
|◆ SQL Server 2012 (x86, x64) (RTM)
◆ SQL Server 2008 R2 SP2 or later
◆ SQL Server 2008 SP3 or later
|◆ SQL 2012 SP1
◆ SQL Server 2008 R2 SP1
◆ SQL Server 2008 SP3
◆ SQL Server 2005
|◆ Backup and recovery of a SQL Server running on IA64.
◆ Backup and recovery of SQL Server 2000.
◆ VSS backup of SQL Server Express Editions.
|◆ SQL Server Express Edition backup||◆ SharePoint Writer save set backup in a default SharePoint installation.
◆ Backup by using the VDI technology workflow.
SQL Server VSS Writers: NMM uses the VSS Writer SqlServerWriter for SQL Server backup and recovery.
NMM supports the following types of backup:
– For all supported SQL Server versions—NMM supports full backup of the SQL Server VSS writer.
NMM does not support the following:
– SQL incremental backup
– SQL differential backup
– Individual filegroups, files, or logs backup
NMM supports the following types of recovery:
– For supported SQL Server versions—NMM supports only full recovery.
– NMM only supports databases in SQL simple recovery mode.
In the Backup command field, type the backup command: nsrsnap_vss_save.exe
In the Application information field, specify the value: NSR_SNAP_TYPE= VSS
To view a list of the application data save sets that are available for backup: nsrsnap_vss_save -v -?
AlwaysOn configuration for SQL Server 2012 :
NMM supports the SQL Server 2012 feature AlwaysOn feature. AlwaysOn allows a database to have multiple replicas. (a maximum number of four secondary replicas).
A database that is configured as AlwaysOn is treated by NMM as a normal database. A backup of the database can be performed from either the primary replica or secondary replica because NMM considers the replicas to be databases that are residing on separate instances. However, there are some restrictions on secondary replicas of an AlwaysOn database and not all backup types can be performed from the secondary replicas.
– To perform backup of secondary replicas, set the Readable Secondary option of SQL Server 2012 AlwaysOn configuration to “Yes.” Enable this option for both primary and secondary replicas because during the backup process the Secondary replicas may become primary and vice versa.
– SQL Server 2012 also introduced the new functionality Availability Group with AlwaysOn. An Availability Group is a logical group of databases that are configured with the AlwaysOn capability and the Availability Group is failed over to other nodes as a group. That is, all the databases that are part of the Availability group are failed over together during failure or manual failover.