Chapter 3. Disaster Recovery Techniques to Protect Your Database

After completing this chapter, you will be able to:

  • Decide which database backup strategy you need

  • Configure the right recovery model

  • Perform full database, differential, and transaction log backups

  • Restore user and system databases

  • Schedule backups

The previous chapter considered security–protecting your data from unauthorized users. This chapter will look at protecting your data from unanticipated loss. Preventing data loss is one of the most critical issues involved in managing database systems. Data can be lost as a result of many different problems:

  • Hardware failures

  • Viruses

  • Incorrect use of UPDATE and DELETE statements

  • Software bugs

  • Disasters, such as fire or flood

To prevent data ...

Get Microsoft® SQL Server™ 2005: Applied Techniques Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial