SQL Server with Mr. Denny:

Storage

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...

July 20, 2015  6:00 PM

If You Thought Database Restores Were Slow, Try Restoring From an EMC Data Domain

Denny Cherry Denny Cherry Profile: Denny Cherry
Backup and restore, backup appliance, Data Domain, EMC, Restore Database, SQL Server

Recently I did something which I haven't had to do for a VERY long time, restore a database off of an EMC Data Domain. Thankfully I wasn't restoring a failed production system, I was restoring to a replacement production system, so I was getting log shipping setup. I've worked in plenty of...


November 19, 2014  7:00 PM

Moving a Multi-TB Database From One Disk To Another

Denny Cherry Denny Cherry Profile: Denny Cherry
Database instance, Database migration, Server migration, SQL, SQL Server, SQL storage, Storage

Recently a client brought me a challenge. They wanted to more a database from one LUN to another. So far this is pretty straight forward. The trick here is that this is a multi-TB instance with several databases which are about 1TB in size, and the instance has a two hour per night maintenance...


September 26, 2014  5:11 PM

Recommended reading from mrdenny for September 26, 2014

Denny Cherry Denny Cherry Profile: Denny Cherry
EMC, EMC Arrays, EMC VNX, Microsoft MVP, SQL Server 2014, SQL Server Express, VMware

On a personal note, today is my 15th wedding anniversary to Kris.  Thank you to my Kris who's put up with me for all these years. This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week.


August 15, 2014  5:19 PM

Recommended reading from mrdenny for August 15, 2014

Denny Cherry Denny Cherry Profile: Denny Cherry
community, Heartbleed, iSCSI, Opex, Recommended reading, SQL Server

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


August 8, 2014  5:24 PM

Recommended reading from mrdenny for August 08, 2014

Denny Cherry Denny Cherry Profile: Denny Cherry
Data Domain, EMC, EMC VNX, EMC World, HIPAA, SQL Server

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


June 20, 2014  8:12 PM

Recommended reading from mrdenny for June 20, 2014

Denny Cherry Denny Cherry Profile: Denny Cherry
Cloud Computing, Managers, Recommended reading, SQL Server, Storage, Storage virtualization

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


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: