It gets rolled back.

Japie Botma (8/24/2016)

---

Steve, not working for longer than another 25 years will be a decision you make, not forced by age. I retired 4 months ago, went immediately on...

Are you allowing this person to "beltloop" you while you're doing your work so they can learn what to do? Are you actually taking the time to mentor this...

Check out Perry Whittle's Stairway to AlwaysOn, especially this bit.

http://www.sqlservercentral.com/articles/cluster/107539/

It's not supported in Azure yet.

I think it's worth remembering that we do all have more time than we think.

There are 168 hours in a week. If we're lucky enough to sleep 8 hours...

So you only have two nodes? Then I'd just take the backups on the primary node.

Is this mirroring or an AlwaysOn Availability Group?

Why are you running backup jobs on an asynchronous replica? The error message you're getting explains why it's not a great idea. In the event of a disaster, wouldn't you...

My comment was in response to this:

As a UK citizen, I always advise anyone considering using cloud storage to first ask themselves whether they're happy about US police, FBI, etc....

They're very pointed/passive-aggressive.

cad.delworth (7/20/2016)

As a UK citizen, I always advise anyone considering using cloud storage to first ask themselves whether they're happy about US police, FBI, etc. all being able basically to...

Do you mean ’ instead of '? A find & replace doesn't work?

(Sorry if I've misunderstood the question.)

Ignore me, I've just found the answer- typical. It's a yes, if anybody else is wondering.

This kind of attitude drives me...