UNSOLVED

m-db

updated

9 years ago

MD

m-db

4 Posts

0

6176

September 11th, 2017 04:00

SQL 2014 - AlwaysOn Cluster Backup Problem

Dear All,

I need your assistance - have exhausted all the troubleshooting options and still wasn't able to get things running.

The problem basically is the inability to backup the databases in a cluster. When I run the client, it only backups up databases that are not protected by cluster...

Environment:

Windows OS :                   Windows Server 2012 R2

SQL :                                 SQL Server 2014

Networker:                         9.0.1 b. 614

Windows Cluster name:    alwayson.ad.xpto.com

Named Instance:               LST-REC

Database name:               CPI

I assume that there may be a configuration problem, but I wasn't able to find it until now.

What I did was - manually create three clients.. One for the Cluster name (LST-REC.ad.xpto.com) and two for the physical servers (svwa-bdc-cpd01.ad.xpto.com and svwa-bdc-cpd02.ad.xpto.com).

The configuration for the three clients are the same - the only difference is that the clients for the physical servers are not in any group and I start the backup only in the client for the cluster name.

This is the information from the information log.

43708:(pid 31960):Start time: Mon Sep 11 11:45:16 2017

153897:(pid 31960):Computer name: SVWA-BDC-CPD01     User name: administrator

Check the detailed logs at 'C:\Program Files\EMC NetWorker\nsr\applogs\nsrsqlsv.log'.

38571:(pid 31960): Bad switch: -o

38562:(pid 31960): Unsupported savegrp option -o will be ignored

107092:(pid 31960):Version information for C:\Program Files\EMC NetWorker\nsr\bin\nsrsqlsv.exe: Original file name: nsrsqlsv.exe Version: 9.0.1.614 Comments: Supporting SQL 2005, SQL 2008, SQL 2008 R2, SQL 2012 and SQL 2014

104810:(pid 31960):Detected application flag NSR_CONSISTENCY_CHECKS set to ALL in NW resources for client lst-rec.

97546:(pid 31960):Back up of Cpi.QA will be excluded as it is part of Availability group. It can be backed up using SQL federated workflow.

154717:(pid 31960):NSR_SERVER : sfli-bk-cpd01.ad.xpto.com

.129292:(pid 31960): Successfully established Client direct save session for save-set ID '1471572332' (svwa-bdc-cpd01.ad.xpto.com:MSSQL$REC:master) with Data Domain volume 'sfdibkcpd01adxptocom.001'.

53085:(pid 31960):Backing up of master succeeded.

129292:(pid 31960): Successfully established Client direct save session for save-set ID '1454795122' (svwa-bdc-cpd01.ad.xpto.com:MSSQL$REC:model) with Data Domain volume 'sfdibkcpd01adxptocom.001'.

53085:(pid 31960):Backing up of model succeeded.

129292:(pid 31960): Successfully established Client direct save session for save-set ID '1438017909' (svwa-bdc-cpd01.ad.xpto.com:MSSQL$REC:msdb) with Data Domain volume 'sfdibkcpd01adxptocom.001'.

53085:(pid 31960):Backing up of msdb succeeded.

Successfully completed databases

==============================

master

model

msdb

lst-rec: MSSQL$REC:             level=full,     33 MB 00:00:14      3 file(s)

completed savetime=1505126737