C H A P T E R  11


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. On the other hand, 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 skill. 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 ...

Get Pro SQL Server 2008 Administration now with the O’Reilly learning platform.

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