Viewing 15 posts - 406 through 420 (of 1,318 total)
I usually do it when I'm setting up the environment, before it goes into Production.
July 24, 2017 at 9:06 am
You need to change it to Synchronous Commit and wait for it to catch up before you do the failover if you want to fail over with no data loss.
July 24, 2017 at 9:00 am
I'm assuming here that you want to query a readable secondary in an AlwaysOn Availability Group, and that:
1) your Availability Group is already configured with a readable replica.
July 24, 2017 at 3:41 am
You can technically set it up on a single-node cluster (but that's kind of pointless). For actual HA you'll need at least one more SQL instance on the same cluster...
July 20, 2017 at 6:21 am
No, it doesn't break the log chain.
July 18, 2017 at 3:07 am
There would definitely have to be consequences. Good managers should manage these things as a matter of course, but very few managers are actually good. It's the same with remote...
July 13, 2017 at 9:17 am
July 13, 2017 at 8:56 am
I own up straight away. There was one time I briefly thought I'd taken out a live trading system, and my blood ran absolutely cold but I went and told...
July 13, 2017 at 6:20 am
A daring editorial, and I'm going to say something controversial here in response. I don't...
July 11, 2017 at 7:41 am
You can't you'll need to take a Full backup before you can take any log backups. Until you take a Full backup the database will be in a state known...
July 7, 2017 at 6:39 am
Agreed. Unless somebody specifically selects a gender designation form they've filled in, it's hugely, hugely problematic to "assign" one on the basis of a finger in the air calculation.
June 30, 2017 at 4:03 am
I'm so jealous of the Vancouver Island plans!
I don't have anything booked for this summer but I'm planning to go to Cape Town in December. Would be nice...
June 28, 2017 at 1:49 am
How frequently are you taking the log backups, and can you improve the frequency so that you have more, (usually) smaller files?
June 27, 2017 at 2:29 am
Viewing 15 posts - 406 through 420 (of 1,318 total)