tailieunhanh - 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ộ | By. . 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 Part VI Enterprise Data Management r- r - Recovery planning is not an isolated topic. Transactional integrity Chapter 66 .

• Cơ sở dữ liệu
• Giáo trình SQL Server 2008
• Microsoft SQL Server 2008
• quản trị dữ liệu
• cài đặt SQL Server 2008
• công cụ của SQL Server 2008
• Giáo trình Microsoft SQL Server 2008
• Quản trị cơ sở dữ liệu
• Cài đặt Microsoft SQL Server 2008
• Cấu trúc trình đơn của Microsoft SQL Server 2008
• Cơ sở dữ liệu SQL Server 2008
• Dịch vụ Report trong SQL Server 2008
• SQL Server Business Intelligence Development Studio
• Bảo mật cơ sở dữ liệu SQL Server 2008
• SQL Server 2008
• Cơ bản SQL Server 2008
• Kiến trúc SQL Server 2008
• Phục hồi cơ sở dữ liệu