Microsoft SQL Server 2014 Unleashed

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, snapshots can be generated from 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 any point, using that baseline snapshot. This procedure can be done any number of times. Figure 29.8 shows how easy it is to simply create a testing reference point (or synchronization point) with a database snapshot.

FIGURE 29.8 Establishing a baseline testing database snapshot before running tests and ...