Đang chuẩn bị liên kết để tải về tài liệu:
Hướng dẫn học Microsoft SQL Server 2008 part 100

NỘI BÀI Tìm hiểu các mô hình phục hồi Sao lưu cơ sở dữ liệu người sử dụng hiểu và làm việc với các bản ghi giao dịch Phục hồi cơ sở dữ liệu bị mất, hệ thống cơ sở dữ liệu bị mất, hoặc máy chủ toàn bộ | www.getcoolebook.com By. -.Y. y . M L r . I . r _LL. f S W W Y . A .- . .v . T- r - ML . - . . V -F 3ti k Y e. -Yfi-v WS w- i i-vt. iiS -. K VA - W 1 S Recovery Planning y cy . - The foundation for this book the Information Architecture Principle introduced in Chapter 2 puts into words the reason why there must be a solid recovery plan. Information is an organizational asset and according to its value and scope must be organized inventoried secured and made readily available in a usable format for daily operations and analysis by individuals groups and processes both today and in the future. It goes without writing that for information to be readily available . both today and in the future regardless of hardware failure catastrophes or accidental deletion there has to be a plan B. Obviously this is an imperfect world and bad things do happen to good people. Since you re bothering to read this chapter I ll be honest and agree that doing backups isn t very exciting. In some jobs excitement means trouble and this is one of them. To a good DBA being prepared for the worst means having a sound recovery plan that has been tested more than once. Consistent with the flexibility found in other areas of SQL Server there are multiple ways to perform a backup each suited to a different purpose. SQL Server offers three recovery models which help organize the backup options and simplify database administration. This chapter discusses the concepts that support the recovery effort which entail both backup and restoration. It seems foolish to study backup without also learning about how restoration completes the recovery. IN THIS CHAPTER Understanding the recovery models Backing up user databases Understanding and working with the transaction log Recovering a lost database a lost system database or the entire server 953 www.getcoolebook.com Part VI Enterprise Data Management r- r - Recovery planning is not an isolated topic. Transactional integrity Chapter 66 .