SQL Server with Mr. Denny:

Backup & recovery


December 18, 2013  2:00 PM

Encryption and Compression



Posted by: Denny Cherry
Backup & recovery, BACKUP DATABASE, Data Loss, Data Security, Database, Database Administration, Database security, Indexing, Security, SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, Storage, Tables

We have a variety of options when it comes to compression and encryption in SQL Server. When using both compression and encryption you...

July 3, 2013  7:00 AM

Backups & the Buffer Pool



Posted by: Denny Cherry
Back To Basics, Backup & recovery, BACKUP DATABASE, SQL Server, Storage

    As we know with Microsoft SQL Server everything is processed from disk and loaded into the buffer pool for processing by the query engine.  So...


December 19, 2012  2:00 PM

Moving a Sharepoint Site Between Farms With Different Templates



Posted by: Denny Cherry
Backup & recovery, BACKUP DATABASE, Database, PowerShell, SharePoint, SharePoint 2012, SQL Server

A client came to be with a pretty scary problem.  Their SharePoint site was totally down.  The databases were there but the actual SharePoint farm was totally dead.  All of the SharePoint tools said that the farm wasn't configured yet so there were some pretty big problems.  Thankfully they had...


November 17, 2012  2:00 PM

Backup Databases on Creation



Posted by: Denny Cherry
Backup & recovery, BACKUP DATABASE, CREATE TRIGGER, Data Loss, Database, Database Administration, DDL Trigger, Recovery, SQL Server, SQL Server 2008 R2, SQL Server 2012, T/SQL, Transactions, Trigger, xp_create_subdir

One of the companies which I work with has the occasion to create new databases when they do releases of their software.  Normally this isn't a problem, except that they are setup to use maintenance plans to handle the backup and pruning of their transaction logs.  As all the new databases are...


June 25, 2012  2:00 PM

Moving huge amounts of data between data centers



Posted by: Denny Cherry
Data Center Build, Migration, Restore Database, SQL Server

Every once and a while I get the fun project of moving a data center from one location to another, often from a Managed Service Provider to either a CoLo facility or to another Managed Service Provider.  When I'm doing this the data sizes typically aren't small.  In the case of my current project...


May 28, 2012  2:00 PM

Figuring out how log shipping is doing



Posted by: Denny Cherry
Backup & recovery, Log Shipping, Migration, Restore Database, SQL Server

A lot of the time when doing data center migrations or system migrations I end up using Transaction Log Shipping to get the data from one SQL Server to another.  I do this for a few reasons.

  1. It's reliable.
  2. It's easy to do (I've got plenty of scripts sitting around to...


February 27, 2012  2:00 PM

Building a new CoLo – Part 1 of n



Posted by: Denny Cherry
Backup & recovery, EMC, SQL Server, Storage, Virtualization, VMware

So if you follow me on twitter you might have seen this tweet a little while back.

Bookmark and Share     0 Comments     RSS Feed     Email a friend


December 27, 2011  2:00 PM

Back To Basics: Why isn’t maintenace automatic?



Posted by: Denny Cherry
Back To Basics, Backup & recovery, Recovery, SQL Server

One of the questions which I see pop up from time to time (especially when I used to work for a VAR that wrote software for small businesses) is why doesn't SQL Server do the maintenance automatically?  Things like checking for corruption (DBCC CHECKDB), index defragmentation, backups, etc. The...


October 31, 2011  2:00 PM

VMware’s vCenter and SQL Server Database Backups



Posted by: Denny Cherry
Backup & recovery, SQL Server, vCenter, VMware

VMware's vCenter system uses SQL Server as it's default database platform.  One thing that needs to be looked into for a lot of VMware installations is the backup setup for the vCenter databases.  Often I find the vCenter databases configured in SIMPLE recovery.  Now this doesn't mean that the...


September 12, 2011  2:00 PM

Cloud probably isn’t going to be a very good backup solution for you



Posted by: Denny Cherry
Backup & recovery, DR, SQL Server

Back on July 19th, there was a blog post that I was pointed to which talked about tossing your backup solution and using cloud for your backup instead.  Basically the points which are made are...


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: