NetWorker

Last reply by 01-09-2023 Solved
Start a Discussion
2 Bronze
2 Bronze
474

SQL cluster backup not visible for recover

Hi All,

We have a NetWorker Server 19.1.6.2 and and SQL cluster with NetWorker Client 18.2.0.1.Build.70.

Node one - XXX1
Node two - XXX2
Cluster - XXX3
Listener - XXX4

Backup 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. 
nwpluginsql.PNG

SQL team said that they see nothing that seems to be a configuration problem.

Save set
MSSQL#AG_XXX4


Backup command
nsrsqlsv -z FEDERATED_SLAVE=true -z FEDINDEX_NAME=MSSQL -z FEDCLIENT_NAME=XXX3 -z NSR_JOB_PARENT_JOBID=0

 

Application information
NSR_CONSISTENCY_CHECKS=FALSE
NSR_SKIP_SIMPLE_DB=TRUE
NSR_SKIP_NON_BACKUPABLE_STATE_DB=TRUE

Remote access
*@*

Solution (1)

Accepted Solutions
2 Bronze
2 Bronze
433

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

Replies (2)
2 Bronze
2 Bronze
434

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

105

@pesza I don't understand your solution can you please eloborate for my understanding 

 

Can you please provide some snippets

Latest Solutions
Top Contributor