TAILIEUCHUNG - Microsoft SQL Server 2008 R2 Unleashed- P112

Microsoft SQL Server 2008 R2 Unleashed- P112:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 1054 CHAPTER 32 Database Snapshots Providing a Testing or Quality Assurance Starting Point Baseline In testing and the QA phases of your development life cycle you often need to conduct tests over and over. These are either logic tests or even performance tests. To aid testing and QA database snapshots can be made of a test database prior to full testing create a testing baseline database snapshot and then the test database can be reverted back to its original state at a moment s notice using that baseline snapshot. This procedure can be done any number of times. Figure shows how easy it is to simply create a testing reference point or synchronization point with a database snapshot. Restore from the BEFORE snashot after testing cycle is complete and can continue with next test. FIGURE Establishing a baseline testing database snapshot before running tests and then reverting when finished. You then just run your test scripts or do any manual testing as much as you want and then revert back to this starting point rapidly. Then you run more tests again. Providing a Point-in-Time Reporting Database If what you really need is a true point-in-time reporting database from which you can run ad hoc or canned reports often a database snapshot can serve this purpose much better than resorting to log shipping or data replication. Key to determining when you can use this database snapshot technique is whether the reporting load on this database server instance can easily support the reporting workload and whether the update transactions against this database are adversely affected by the database snapshot overhead of each Download from When to Use Database Snapshots 1055 transaction. Figure shows the typical database snapshot configuration for one or more database snapshots that are to be used for reporting. Database Snapshot 12 00AM Reporting Snapshot FIGURE A point-in-time reporting database via a database snapshot. 32 Remember this is a .

TỪ KHÓA LIÊN QUAN
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.