O'Reilly logo

Pro SQL Server 2012 Administration by Sylvester Carstarphen, Ken Simmons

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required