SQL Server with Mr. Denny:

Backup & recovery


August 22, 2011  2:00 PM

There’s a little something to keep in mind when restoring a SQL replication publisher



Posted by: Denny Cherry
Backup & recovery, Replication, Restore Database

So the other day I had to restore the SQL Server replication publisher.  When I restored it I made sure to use the KEEP_REPLICATION option on the restore (also available in the SSMS UI) so replication should come back online.  However when I restarted the log reader I the following error...

July 7, 2011  2:00 PM

How HyperBac worked for me



Posted by: Denny Cherry
Backup & recovery

I recently installed HyperBac on a clients SQL Server to reduce the amount of space needed to store their backups.  Specifically we were looking to reduce the amount of space the log backups took, but I was curious to see how much space the full backups would be reduced by. The full backups...


May 30, 2011  2:00 PM

How to use the WITH MOVE when you don’t know the logical database file names.



Posted by: Denny Cherry
Restore Database, SQL Server

When doing a database restore and you want to move the physical database files from one disk to another, or from one folder to another you need to know the logical file names.  But if you can’t restore the database how do you get these logical file names?  By using the RESTORE FILELISTONLY...


March 25, 2011  2:00 PM

SQL Backup Compression and Backup Dedup are mortal enemies



Posted by: Denny Cherry
Backup & recovery, compression, SQL Server, SQL University, Storage

If you have a modern tape backup solution you probably have some sort of dedup process in your backup environment.  What these deduplication processes do normally is look at the data which is being written to the backup platform and remove duplicate values in order to save space on the tape backup...


February 7, 2011  2:00 PM

If you aren’t doing backups, you aren’t doing your job.



Posted by: Denny Cherry
Backup & recovery, BACKUP DATABASE, SQL Server, SQL Server 11, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012

Apparently people still haven't figured out that taking backups of SQL Server databases is actually a requirement of having a SQL Server database.  There was a conversation recently on Twitter about yet another forum question where the OP talked about the crashed database that they had without any...


January 3, 2011  2:00 PM

If you are going to provide SQL Server support, you should probably know what you are doing.



Posted by: Denny Cherry
Backup & recovery, BACKUP DATABASE, RackSpace

So the other day I got a ticket opened by my companies Managed Service Provider.  There was a backup failure on one of our databases.  The response from the hosting provider was:

This failed due to a "Error: 3041, Severity: 16, State: 1." error. This is because you...


February 2, 2010  11:00 AM

Taking backups is good, but testing them is better.



Posted by: Denny Cherry
Backup & recovery, BACKUP DATABASE, Restore Database, Testing

I bet that if asked when the last time the database backup was taken and if it succeeded you would know off of the top of your head when that was.  But if I asked you when the last time your database was restored successfully would you know?


October 10, 2009  10:58 PM

If you want to keep the data, back it up; even if it’s your cell phone!



Posted by: Denny Cherry
Backup & recovery, Cell Phone, Data Loss

Another major data loss is showing that if you want to keep your data, its up to you to back it up.  T-Mobile customers who have a sidekick phone are being told this weekend that they...


August 17, 2009  11:33 AM

Learn to use the COPY_ONLY flag for one off backups



Posted by: Denny Cherry
Backup & recovery, BACKUP DATABASE

Taking a full backup when doing major database upgrades is a great idea.  However if you are taking differential backups this one off full backup will break the differential backup chain.


June 1, 2009  1:00 PM

Clean up the backup history



Posted by: Denny Cherry
Backup & recovery, Database Administration, sp_delete_backuphistory

Something that most people don't release needs a little TLC in SQL Server is the backup history. Every time a database is backed up records are written about it.  Over time this can add up to a lot of useless data floating around the SQL Server in the msdb database. If you like to use the UI...


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: