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

Anyone have a script for TDP SQL backups?

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

  1. droach

    droach ADSM.ORG Senior Member

    Joined:
    Jan 7, 2008
    Messages:
    201
    Likes Received:
    4
    Occupation:
    I'm thinking...
    Location:
    Cut and Shoot, Texas
    Trying to script backups for some SQL clusters that have AlwaysOn availability groups. Would like to have one script that can be deployed on each node in the cluster and have it smart enough to know if it is running on the preferred node for doing the backup. Anyone figured this out?
     
  2.  
  3. ianr27

    ianr27 Active Newcomer

    Joined:
    Jul 3, 2017
    Messages:
    5
    Likes Received:
    1
    You can just run the backup as if it was a normal TDP for SQL using a * to backup all databases.

    In the setting for the TDP you can change the priority of nodes and how to use the replica's.
     

Share This Page