May 2020 - Steve Stedman

For merge publications, the version of the Subscriber must not exceed the version of the Publisher

By SteveStedman Posted on May 29, 2020 Posted in Replication, SQL 2014, SQL 2016, SQL 2017, SQL 2019 No Comments

Working on a recent SQL Server merge replication project we needed to update some of the servers in a merge replication scenario without upgrading all of them. Consider a merge replication setup with a publisher, a distributor and 2 or more subscribers all on the same version of SQL Server, and you need to upgrade the SQL Server version on …

For merge publications, the version of the Subscriber must not exceed the version of the Publisher Read more »

TSQL To List Recent Backups

By SteveStedman Posted on May 4, 2020 Posted in SQL Server No Comments

Doing some recent investigation to find out why backups where not showing up where they were expected to be I put together this script to help track down recent backups. Normally I would use Database Health Monitor and the cool backup reports, but I didn’t have that installed on the server needing help. The output looks something like this, although …

TSQL To List Recent Backups Read more »

Month: May 2020

For merge publications, the version of the Subscriber must not exceed the version of the Publisher

TSQL To List Recent Backups

Login