NMM for Microsoft for SQL VSS

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.

Not Supported Supported
◆ 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.

Backups
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

Recoveries
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.

Configuring client resources:

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.

Advertisements

About Ahmad Sabry ElGendi

https://www.linkedin.com/pub/ahmad-elgendi/94/223/559
This entry was posted in E20-597. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s