Advertisement

Managing Backups

  • Ken Simmons
  • Sylvester Carstarphen

Abstract

Understanding backups is extremely important for every database administrator (DBA)—it can make or break your career. If you need to restore a database, you can be a hero in a matter of minutes. Conversely, if you don’t have a good backup to restore, you may end up looking for a new job. In our opinion, having the knowledge to properly back up and restore a database is the most important skill a DBA can possess. That being said, we think backing up a database is often the most easily overlooked process. It’s easy to set up a maintenance plan or backup job and think you are covered—a kind of set-it-and-forget-it mentality. The problem with this attitude is that you do not know a backup is being performed incorrectly until you need to use it, which is not the best time to find out. There are several backup options available in SQL Server 2012 that you should master to ensure you do not find yourself explaining why you cannot restore a database everyone thought was being backed up.

Keywords

Recovery Model Backup Statement Differential Base Backup Operation Backup Device 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Ken Simmons and Sylvester Carstarphen 2012

Authors and Affiliations

  • Ken Simmons
  • Sylvester Carstarphen

There are no affiliations available

Personalised recommendations