Microsoft Press microsoft sql server 2005 PHẦN 8

Sau khi mô tả các tùy chọn linh hoạt của Microsoft SQL Server để sao lưu cơ sở dữ liệu, chương này giải thích làm thế nào để khôi phục lại những bản sao lưu phục hồi dữ liệu lên đến một điểm cụ thể trong thời gian. Bạn cũng sẽ tìm hiểu làm thế nào để di chuyển cơ sở dữ liệu bằng cách sử dụng sao lưu / khôi phục lại, tách / đính kèm, hoặc cơ sở dữ liệu Sao chép | Lesson 1 Creating a Database Snapshot 607 Lesson Summary A Database Snapshot is a point-in-time read-only copy of a source database that exists on the same SQL Server instance as the source database. As pages are changed in the source database the original image of the data page is written into the sparse files of the Database Snapshot to preserve the state of the data at creation time. Although a Database Snapshot can be queried like any other database you are not allowed to modify data or structural elements. A Database Snapshot also cannot be used for backup restore operations. Even though it is required to exist on the same SQL Server instance as the source database a Database Snapshot can be created against a mirror database within a Database Mirroring session. Lesson Review The following questions are intended to reinforce key information presented in this lesson. The questions are also available on the companion CD if you prefer to review them in electronic form. NOTE Answers Answers to these questions and explanations of why each answer choice is right or wrong are located in the Answers section at the end of the book. 1. Which operations can be performed against a Database Snapshot A. BACKUP DATABASE B. ALTER DATABASE C. SELECT COLUMN1 COLUMN2 FROM TABLE D. UPDATE TABLE1 SET COLUMN1 4 2. You can create a Database Snapshot against which types of databases Choose all that apply. A. User database B. Master database C. Another Database Snapshot D. Mirror database 608 Chapter 16 Managing Database Snapshots 3. What data is contained within a Database Snapshot Choose all that apply. A. All original pages of the source database B. Only the original image of pages changed since the Database Snapshot was created C. A catalog of changed pages D. Metadata about the database objects Lesson 2 Reverting a Database from a Database Snapshot 609 Lesson 2 Reverting a Database from a Database Snapshot A Database Snapshot provides a point-in-time copy of a source database. .