Anyone have a script for TDP SQL backups?

[droach]

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?

 

[ianr27]

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.