Hi All,We have a NetWorker Server 126.96.36.199 and and SQL cluster with NetWorker Client 188.8.131.52.Build.70.Node one - XXX1Node two - XXX2Cluster - XXX3Listener - XXX4Backup which saved by the Cluster, is not visible when trying to recover from NetWorker Plugin for SQL Server Management Studio, but the backups are running fine, Log and Data too.At the Plugin, SQL Server Instance: XXX3\XXX4, so it thinks that the listener is an instance, but there is no instance like that at all. Other similar configurations are working fine.
SQL team said that they see nothing that seems to be a configuration problem.
Backup commandnsrsqlsv -z FEDERATED_SLAVE=true -z FEDINDEX_NAME=MSSQL -z FEDCLIENT_NAME=XXX3 -z NSR_JOB_PARENT_JOBID=0
Application informationNSR_CONSISTENCY_CHECKS=FALSENSR_SKIP_SIMPLE_DB=TRUENSR_SKIP_NON_BACKUPABLE_STATE_DB=TRUERemote access*@*
Go to Solution.
Issue was solved with the CLI command, even if the XXX4 is the listener, for some reason, the networker marked it as an instance. nsrsqlrc.exe -s serverhost -c XXX3 -C "'compliant data'" -t "08/25/2022 07:00:00 PM" -S normal -a "SKIP_CLIENT_RESOLUTION=TRUE" -d MSSQL:DB_copy MSSQL$xxx4#AG_XXX4:DB
View solution in original post
@pesza I don't understand your solution can you please eloborate for my understanding
Can you please provide some snippets