tdp for sql backing up passive

[GMartin]

Has anyone found the command that will backup the passive copy of a sql cluster like you can with DAG groups in Exchange. I've gone through the user guide, searched google, and this forum, but can't find any reference to it. Is this even possible for SQL?

THe app team is insisting the backup be performed on the passive copy.


TDP version 6.4
SQL Server 2012
FCM version 3.2

Thanks in advance
Garry

 

[moon-buddy]

By passive, do you mean a database replica on a passive node and not accessed by the SQL engine?

If so, why not backup using the BA Client the related MDF and LDF files?

 

[GMartin]

By passive, do you mean a database replica on a passive node and not accessed by the SQL engine?

If so, why not backup using the BA Client the related MDF and LDF files?

Ed, yes the passive copy is replicated. However it may be accessed by SQL. Performing a file level backup is not an option (reasons for this is just too much to type).

 

[GMartin]

So after adding "always on" to my search i found the information i was looking for. It's copied below in case anyone else needs it.

1. Start the Management Console.
2. In the Management section of the window, click Protect Data next to the SQL Server workload.
3. Click Properties in the Actions pane.
4. Click the AlwaysOn Preferences property page.
5. In the Availability group field, select the AlwaysOn Availability Group for which you want to set up backup preferences.
6. In the Preferred replica field, select which replica is the preferred replica on which to run scheduled backups.
   • Select Prefer Secondary replica if you want scheduled backups to occur on a secondary replica, if it is available. Otherwise, use the primary replica for the scheduled backup.
   • Select Secondary only if you want scheduled backups to occur only on a secondary replica.
   • Select Primary if you want scheduled backups to occur only on the primary replica.
   • Select Any replica if you want scheduled backups to occur on any availability replica.
7. For each availability replica listed in the Availability replicas list box, specify whether it is a candidate for running scheduled backups by specifying the backup priority for that replica. A value of 1 has the lowest priority, and a value of 100 has the highest priority. A value of 0 indicates that the replica is excluded from schedule backup operations.
8. Click OK to save your configuration and exit the Data Protection Properties page. The settings are saved to the tdpsql.cfg file and can be replicated to the other replicas in the availability group.