August 2015 - Andy M Mallon

Will Transaction Log backup to Nul break Always On Availability Group configuration?

August 31, 2015 Andy 0

Question Imagine we have two nodes participating in SQL 2012 AO. This is a test instance. During one of the index rebuild operation the log was grown up really big (250 GB). We are unable to back it up due to space constraint. What if … [Read More]

Tip: Master Control Panel

August 18, 2015 Andy 0

Shortcuts & tips from an Impatient DBA #9 This series of short posts will demonstrate some lesser-known features, keyboard shortcuts, and other tips that make my day as a DBA more productive. None of these are groundbreaking super-secret features–they are the little things that I … [Read More]

Andy M Mallon - AM²

Databases & Diversity — Checking Integrity

Month: August 2015

Will Transaction Log backup to Nul break Always On Availability Group configuration?

Tip: Master Control Panel