SQL Server with Mr. Denny:

Backup & recovery


March 8, 2009  2:20 AM

Developing a SQL Server Database Backup Plan



Posted by: Denny Cherry
Article, Backup & recovery

Last week I published a new article on Enterprise IT Planet called "Developing a SQL Server Database Backup Plan" in which I go...

January 2, 2009  8:46 PM

Mirroring isn’t a backup solution



Posted by: Denny Cherry
Backup & recovery, Database security, JournalSpace.com, SecurityFightClub, SQL Injection

In case you live under a rock and haven't heard about Journalspace.com's little mistake, they have gone out of business due to a database problem.  Here's a


December 29, 2008  11:00 AM

Order To Restore Database Backups In



Posted by: Denny Cherry
Backup & recovery, Restore Database, RESTORE LOG

I'm often asked (both online and offline) once you have all your database backups, in what order to they need to be restored in? I've actually asked this very question to senior level DBAs as an interview question before, and gotten some very interesting answers. When restoring your database...


August 25, 2008  11:00 AM

How to setup a server to read log files nightly.



Posted by: Denny Cherry
Backup & recovery, KILL, Log Shipping, Recovery, RESTORE LOG, SQL Server 2005, xp_delete_file, xp_dirtree

So you've been tasked with setting up a quick and dirty reporting server.  The goal is to restore the log files from the production server to the reporting server nightly.  The backups are simple, use the SQL Maintenance plan to backup the logs, and then copy them to the remote machine.  But...


August 11, 2008  11:00 AM

Back To Basics: The RESTORE DATABASE Command



Posted by: Denny Cherry
Back To Basics, Restore Database, SQL

The restore database command is what is used to recover a database which has been backed up using the BACKUP DATABASE command.  The syntax of the RESTORE DATABASE...


April 1, 2008  6:43 PM

New Article: Tips for scheduling and testing SQL Server backups



Posted by: Denny Cherry
Article, Backup & recovery

I've just published a new tip on SearchSQLServer.com called Tips for scheduling and testing SQL Server backups.  In it I'm talking...


March 16, 2008  9:39 PM

Webcast Recover the data, the whole data and nothing but the data you need available for viewing



Posted by: Denny Cherry
Backup & recovery, Quest Software, Webcam

The webcast which I did with Quest Software a couple of weeks ago "   Bookmark and Share     0 Comments     RSS Feed     Email a friend


February 29, 2008  12:01 AM

Webcast: Recover the Data, the Whole Data and Nothing but the Data You Need



Posted by: Denny Cherry
Backup & recovery, LiteSpeed, Quest Software, Webcam

Coming on the heals of the extremely successful webcast "Under The Hood of SQL Server - Checking Out Internals", Quest Software has asked me to co-present another webcast.  This one is entitled "

Bookmark and Share     0 Comments     RSS Feed     Email a friend


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: