Microsoft® SQL Server 2012 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 taken 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 28.8 shows how easy it is to simply create a testing reference point (or synchronization point) with a database snapshot.

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