1. Please help support our sponsors by considering their products and services.
    Our sponsors enable us to maintain high-speed Internet connection and fast webservers.
    They support this free information and knowledge exchange forum service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions

FMY5052E An error occurred trying to set the requested configuration option.

Discussion in 'Microsoft SQL Server' started by droach, Oct 5, 2017.

  1. droach

    droach ADSM.ORG Senior Member

    Joined:
    Jan 7, 2008
    Messages:
    204
    Likes Received:
    4
    Occupation:
    I'm thinking...
    Location:
    Cut and Shoot, Texas
    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?
     
  2.  

Share This Page