SQL Server with Mr. Denny:

SQL Server transaction logs

1

August 12, 2015  6:00 PM

The concurrent snapshot for publication ‘X’ is not available because it has not been fully generated or the Log Reader Agent is not running to activate it. If generation of the concurrent snapshot was interrupted, the Snapshot Agent for

Denny Cherry Denny Cherry Profile: Denny Cherry
Replication, Snapshot, SQL error messages, SQL replication, SQL Server, SQL Server replication, SQL Server transaction logs, SQL transaction logs, Transaction logs

Recently I was working on SQL Server Replication for a client, specifically removing and reading a table from replication to fix a different problem. After putting the table back and running the snapshot agent to create a differential snapshot I was greeted with the error message "The concurrent...

June 27, 2015  5:36 AM

Recommended reading from mrdenny for June 26, 2015

Denny Cherry Denny Cherry Profile: Denny Cherry
Internet of Things, Net Neutrality, SQL Server, SQL Server transaction logs

This week I’ve found some great things for you to read. These are a few of my favorites that...


June 4, 2014  4:00 PM

Hekaton and Your Transaction Log

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL performance, SQL Server, SQL Server 2014, SQL Server transaction logs

Hekaton (aka. In Memory OLTP Tables) is awesome. Things run very fast through the system, pushing you to 98x the speed of normal tables. But be careful. You'll need to know well in advance how much transaction log space you are going to need. You see there's a little gotcha that I ran into...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: