Unsolved
This post is more than 5 years old
28 Posts
0
861
July 12th, 2016 03:00
Avamar - few SQL DBs are not listed in "Windows SQL" plug-in for backup.
Hi All, Few SQL DBs of one of the SQL client are not listed in "Windows SQL" plug-in in Group of "Backup, Restore and Manage" window. Logged in to SQL server, "NT AUTHORITY\SYSTEM" having "sysadmin" server role in Login Properties. Restarted Avamar backup agent services but no luck. Kindly help me. Avamar Server version :- 7.1.0.370 Avamar Client (FS and SQL) version :- 7.1.100.370 SQL SB version :- 2014 OS version :- Win 2012
0 events found
No Events found!


gautamgp
226 Posts
1
July 12th, 2016 21:00
if they are part of Always on Availability group. Then you can create a avsql.cmd file under var directory and add the following line,
--show_db_in_availability_group=true
restart the backup agent service and this should let you see the DB's.
SubhashD1
28 Posts
0
August 13th, 2016 09:00
Actually I am looking into the physical Nodes. Later I checked in SQL AlwaysOn "Listener Name" in Domain. It was showing the databases.