Announcement Banner
UNSOLVED

rutherfordtx

updated

11 years ago

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?