Backing Up a Database
Unlike a typical operating system backup that can be performed only when major changes are made to an installation, your databases must be backed up regularly. The more heavily the databases are modified, the more frequently they must be updated. In this section, you'll see why you need backup and restoration plans. You'll also learn about recovery models, the different backup types, and how to perform the actual backups. If you abide by the recommendations in this section, your user data will be safe.
Creating a Backup Plan
An effective backup plan will include what data should be backed up, how it should be backed up, when it should occur, and how it will be restored in the event of an emergency. SQL Server provides the ...
Get SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond 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.
