Tony Davis argues that the WITH REPLACE option of the RESTORE DATABASE command is a case where the naming of the option masks its true "JFDI" nature…  Read more...

Today we have an editorial reprinted from April 27, 2005. Steve Jones is on vacation, so we are reprinting this look at backup strategies and media.  Read more...

Today Steve Jones looks at the new release of restore technology from Red Gate software that allows you to "fool" SQL Server.  Read more...

When is backup not enough? Steve Jones talks about a few things that can cause you issues and a backup can't help you recover from.  Read more...

Steve Jones talks about the loss of data, and how it can impact your life. And why you want to be sure that your restores are ready in the event of a disaster.  Read more...

The need to archive data is becoming more and more important as data sizes grow. However when you choose to archive data, you might need to reconsider how your DR plan is structured.  Read more...

Should rolling back a restore be an option for SQL Server? Steve Jones talks about the possibilities in today's editorial and where it might come in handy.  Read more...

One of the core things a DBA must do is ensure backup and recovery of data. This Friday Steve Jones asks about your tolerance for safety and backup data in a Friday poll.  Read more...

How many times have you wanted to restore a database to an earlier version? Today Steve Jones asks why can't we do this and includes a way for you to vote on this.  Read more...

A recent crash of the popular Coding Horror blog brings the responsibility of backups to the front of today's editorial. See if you agree with Steve Jones and his take on backups and restores.  Read more...

One of the very common things that is needed in SQL Server is performing a restore of a database. It's also one of the most important things that needs to take place. So why isn't this a simpler process? Steve Jones wonders why we can't make this a simpler process.  Read more...

For the Friday Poll this week, Steve Jones is wondering what type of data protection you use at home for your information. Especially those all important family photos.  Read more...

With the proliferation of high availability & specialist online Backup companies, do we really have any excuses left to NOT have an offsite backup location, even if it is in the Cloud? Brad things not...  Read more...

Are tape systems obsolete? A recent incident has Steve Jones thinking perhaps not.  Read more...

One thing most DBAs try to avoid whenever possible is unexpected downtime. It still happens, and we have to deal with it. This Friday Steve Jones asks in the poll how much it happens to you.  Read more...

Backup verification is a vital part of a well-designed database maintenance plan and yet some DBAs neglect to do it. Brad McGehee ownders why.  Read more...

One thing most DBAs try to avoid whenever possible is unexpected downtime. It still happens, and we have to deal with it. This Friday Steve Jones asks in the poll how much it happens to you.  Read more...

Steve Jones talks about the potential risk issues of multiple backups in one file.  Read more...

While most DBAs might never encounter the legal aspects of their professional, Phil Factor brings to light a few things that you might want to be aware of in these litigious times.  Read more...

Running backups is enough for disaster recovery, right? That's a myth that could get you into trouble. Steve Jones explains there's more that's needed.  Read more...