CHAPTER 8

image

Database Backups and Recovery

Before inserting and manipulating the data in the database you have created in the previous chapters, it is a good idea to back it up so that if things go wrong, it will be possible to recover the data back to a stable point.

What is abundantly clear when working with any sort of system where data are held is that there must be a comprehensible and workable backup and recovery strategy in place for when things go wrong. The recovery may also be required to cater to problems from a hardware failure due to an act of God. In any of these instances, we may move to an offsite location, which is a building a ...

Get Beginning SQL Server for Developers, Fourth Edition 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.