droach
ADSM.ORG Senior Member
I have a SQL cluster with a database in an 'AlwaysOn' availability group. When I try to backup the db I get this error and no backup occurs:
FMY5052E An error occurred trying to set the requested configuration option
Here is my command:
tdpsqlc backup testdb FULL /ALWAYSONPriority /tsmoptfile=C:\Progra~1\Tivoli\TSM\TDPSql\dsm.opt /SQLSERV=server1\TEST_AG /logfile=C:\Progra~1\Tivoli\TSM\TDPSql\debug.txt
All other databases backup just fine, but they are not in the AAG.
There is nothing more in any of the logs so I don't have much to go on for troubleshooting. The SQL setting is set to 'Prefer Secondary', and this backup is being attempted on the secondary server. Has anyone else run across this issue backing up SQL databases in AlwaysOn availability groups?
FMY5052E An error occurred trying to set the requested configuration option
Here is my command:
tdpsqlc backup testdb FULL /ALWAYSONPriority /tsmoptfile=C:\Progra~1\Tivoli\TSM\TDPSql\dsm.opt /SQLSERV=server1\TEST_AG /logfile=C:\Progra~1\Tivoli\TSM\TDPSql\debug.txt
All other databases backup just fine, but they are not in the AAG.
There is nothing more in any of the logs so I don't have much to go on for troubleshooting. The SQL setting is set to 'Prefer Secondary', and this backup is being attempted on the secondary server. Has anyone else run across this issue backing up SQL databases in AlwaysOn availability groups?
