C H A P T E R  10

Managing Backups

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 backup 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 ...

Get Pro SQL Server 2012 Administration now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.