On my broken replication lab, removing a publication failed with: Could not delete the subscription at Subscriber ‘SubServer’. Here is the command that fixed it.
SQL SERVER – Upgrade Error – Upgrading Subscription Settings and System Objects in Database [DBName].
A patch failed at “Upgrading subscription settings and system objects in database” with invalid object MSreplication_subscriptions. Here is the fix.
SQL SERVER – FIX: Unable to Create Distribution Database on a UNC Share – Configure Distribution
With SQL Server on a UNC share, the Configure Distribution wizard refuses network paths for the distribution database. Here is how to create it anyway.
SQL Authority News – Brent Ozar Unlimited Office Hours 2018/4/4 – Fun Experience
I joined Brent, Richie and Tara for Brent Ozar Unlimited office hours and answered live questions, from replication latency to disk space. Here is the list.
SQL SERVER – Upgrade Error – ALTER DATABASE Statement Not Allowed Within Multi-statement Transaction
A failed SQL Server 2014 SP2 left the service down with: ALTER DATABASE statement not allowed within Multi-statement Transaction. Here is how to fix it.
Avoiding Database Downtime via Replication – SharePlex
Database Downtime is the scariest word for any DBA, because it means the business has stopped. Here is how replication with SharePlex helps you avoid it.
SQL SERVER – FIX: The Log for Database Cannot be Shrunk Until All Secondaries Have Moved Past the Point Where the Log was Added
Shrinking a bloated AlwaysOn log gave me: the log cannot be shrunk until All Secondaries have moved past the point where the log was added. Here is the fix.