
UNSOLVED
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
Responses (0)
Solutions (0)
