AG Backup Preference

Question

AG Backup Preference

Steve Jones - SSC Editor

SSC Guru

Points: 736494
More actions
December 7, 2016 at 8:37 pm

#75755

Comments posted to this topic are about the item AG Backup Preference
December 9, 2016 at 12:55 am

This was removed by the editor as SPAM

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

TimCarrett Default port Points: 1484 More actions · Answer 1

I think the question could be ambiguous as I took it that you only wanted the backup to occur on the Secondary hence I choose Secondary_Only.

"I want to set the backup preference for my SalesAG Availability Group to have backups occur on the secondary when it is running."

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 2

TimCarrett (12/8/2016)
I think the question could be ambiguous as I took it that you only wanted the backup to occur on the Secondary hence I choose Secondary_Only.
"I want to set the backup preference for my SalesAG Availability Group to have backups occur on the secondary when it is running."

Bit of a trick question yes 🙂

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

edwardwill SSCertifiable Points: 5856 More actions · Answer 3

TimCarrett (12/8/2016)
I think the question could be ambiguous as I took it that you only wanted the backup to occur on the Secondary hence I choose Secondary_Only.
"I want to set the backup preference for my SalesAG Availability Group to have backups occur on the secondary when it is running."

Me too.

BillLudlow SSCertifiable Points: 6553 More actions · Answer 4

I agree I thought it was only to occur on the Secondary when it was running and not the primary.

Doh!

paul s-306273 SSChampion Points: 10730 More actions · Answer 5

TimCarrett (12/8/2016)
I think the question could be ambiguous as I took it that you only wanted the backup to occur on the Secondary hence I choose Secondary_Only.
"I want to set the backup preference for my SalesAG Availability Group to have backups occur on the secondary when it is running."

Me too - but I still took a punt.

Luis Cazares SSC Guru Points: 183706 More actions · Answer 6

I don't find the confusing part. Or maybe I just noticed the 3 hints to the correct answer.

I need to ensure the databases are backed up while minimzing load on the primary. I want to set the backup preference for my SalesAG Availability Group to have backups occur on the secondary when it is running

Further explanation on my reasoning:

ensure the databases are backed up - It means that backup jobs should always succeed, not only when the secondary is running.

minimzing load on the primary - It means that there would still be load on the primary.

backups occur on the secondary when it is running - This shows that there should happen something else when the seconday is not running.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

sipas Hall of Fame Points: 3828 More actions · Answer 7

Luis Cazares (12/8/2016)
I don't find the confusing part. Or maybe I just noticed the 3 hints to the correct answer.
I need to ensure the databases are backed up while minimzing load on the primary. I want to set the backup preference for my SalesAG Availability Group to have backups occur on the secondary when it is running
Further explanation on my reasoning:
ensure the databases are backed up - It means that backup jobs should always succeed, not only when the secondary is running.
minimzing load on the primary - It means that there would still be load on the primary.
backups occur on the secondary when it is running - This shows that there should happen something else when the seconday is not running.

I agree - no ambiguity for me - multiple clues to the right answer.

George Vobr SSChampion Points: 10010 More actions · Answer 8

sipas (12/8/2016)
Luis Cazares (12/8/2016)
I don't find the confusing part. Or maybe I just noticed the 3 hints to the correct answer.
I need to ensure the databases are backed up while minimzing load on the primary. I want to set the backup preference for my SalesAG Availability Group to have backups occur on the secondary when it is running
Further explanation on my reasoning:
ensure the databases are backed up - It means that backup jobs should always succeed, not only when the secondary is running.
minimzing load on the primary - It means that there would still be load on the primary.
backups occur on the secondary when it is running - This shows that there should happen something else when the seconday is not running.
I agree - no ambiguity for me - multiple clues to the right answer.

+1

Interesting question, but I had to read it repeatedly several times...;-)

Thanks for this question Steve.

Steve Jones - SSC Editor SSC Guru Points: 736494 More actions · Answer 9

I can see an ambiguous pronoun in there (bad Steve). Corrected