http://www.sqlservercentral.com/blogs/steve_jones/2011/08/15/when-do-you-take-a-full-backup_3F00_/

Printed 2014/04/20 10:40AM

When Do You Take a Full Backup?

By Steve Jones, 2011/08/15

This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for a few deliveries in 2011.

When is a Full Backup Taken?

Most people might answer this with “every day”, or “as often as needed”, but those are a little nebulous, and not necessarily correct.

I do recommend that you backup as often as you can, which is every day for most people. Those with large databases might go once a week, or even once a month, but you want to get a full backup periodically. If you have a really large database, say 50TB or greater (in 2011), you might opt for a yearly SAN snapshot of some kind, but you need some full backup as a base.

So when do you backup your database? Here’s a list of some times you might think about:

That last one might throw people, but I’ve seen more than a couple situations where someone recovered a database in a DR situation and never setup backups. And there was another failure.

Whenever you create a database, either from scratch or after a restore, make a backup.

* Note that if you have Enterprise Edition or above, you can use Database Snapshots to substitute for a full backup in some of these situations.


Filed under: Blog Tagged: Backup/Recovery, disaster recovery, presentations, sql server, syndicated, TopTenSkills

Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.