1. Community Tip: Please Give Thanks to Those Sharing Their Knowledge.
    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.
  2. Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

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:
    198
    Likes Received:
    3
    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