Chapter 7. Database Backup and Recovery
Now that we have created a major part of the database in the previous chapters, and before moving on to inserting and manipulating the data, this is a good point to take a moment to back up the database, just so that if things go wrong, it is possible to recover back to a stable point.
What is abundantly clear when working with any sort of system where data is 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 ranging from a hardware failure to an act of God. In any of these instances, we may move to an offsite location, which is a building a safe distance away from our current building ...
Get Beginning SQL Server 2008 Express for Developers: From Novice to Professional 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.
