
Attachment uploads are currently disabled. This is a temporary situation and will resume as normal in the coming days.
UNSOLVED
R
rutherfordtx
2 Posts
0
1607
October 15th, 2015 08:00
NMM Command Line with SQL 2014 Availability Groups
We have been testing out the Networker Command line tools (version 8.2) as a way to backup our SQL servers but still be able to use stored procedures and Agent jobs to control the backups. We use xp_cmdshell to launch the command line tools
We were having no issues until we started trying to backup databases that are members of an AG group.
I have an AG named testAG and the AdventureWorks2014 database is a member of it
I have tried running the command using the AG name:
nsrsqlsv.exe -s [networkerserver] -l full -b "pool_01" -g "non_prod_sql_daily" "MSSQL#testAG:adventureWorks2014"
and even tried using the -a switch and adding the Windows cluster name.
in both cases, the process hangs and no backup is performed. I have to restart the SQL service to kill the process.
Has anyone had any luck using the NMM command line tools with SQL 2014 Availability groups?
Responses (0)
Solutions (0)
