AG Backup Priority

Question

Post reply

AG Backup Priority

Steve Jones - SSC Editor

SSC Guru

Points: 736183
More actions
December 17, 2016 at 11:04 am

#77314

Comments posted to this topic are about the item AG Backup Priority
December 19, 2016 at 12:19 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

BillLudlow SSCertifiable Points: 6553 More actions · Answer 1

I got it wrong, because I read it as wanting the possible back up priorities, which start at 1 and go to 100.

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 2

BillLudlow (12/19/2016)
I read it as wanting the possible back up priorities, which start at 1 and go to 100.

Eh? They start at 0 though.

BillLudlow SSCertifiable Points: 6553 More actions · Answer 3

But 1 is the lowest priority, isn't it?

Must be too many mince pies, muddled my brain cell.

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 4

Beatrix Kiddo

SSC-Dedicated

Points: 32407

December 19, 2016 at 4:31 am

#1918648

Oh yeah, I see what you're saying; apologies.

BillLudlow SSCertifiable Points: 6553 More actions · Answer 5

Yeah 0 is no backups, so it's more of a status than a back-up priority.

I wuz robbed

:0(

George Vobr SSCrazy Eights Points: 9996 More actions · Answer 6

If you were looking for information on this MSDN article https://msdn.microsoft.com/en-us/library/hh710053.aspx ,

the answer would not be easy. I would probably give 1..100. There is no explanation of the value of nil.

Fortunately in the MSDN article https://msdn.microsoft.com/en-us/library/ff878601.aspx are all informations complete.

Revenant SSC-Forever Points: 42467 More actions · Answer 7

BillLudlow (12/19/2016)
I got it wrong, because I read it as wanting the possible back up priorities, which start at 1 and go to 100.

+1

TomThomson SSC Guru Points: 104773 More actions · Answer 8

BillLudlow (12/19/2016)
Yeah 0 is no backups, so it's more of a status than a back-up priority.
I wuz robbed
:0(

Me too. The page is very clear that 1 is the lowest backup piority and 100 the highest, which means 0 is not a backup priority because if it were 1 couldn't be the lowest.

Tom

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 9

Thanks for the question.

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