Microsoft® SQL Server 2012 Unleashed

Using Database Snapshots with Testing and QA

Reverting to a “golden” copy of a database via a database snapshot is going to be popular going forward because of the simplicity that creating and reverting provides. Testing and QA groups will thrive on this feature, and this will directly affect the velocity of testing in your organization. With the increase in the frequency and stability of your testing and QA environments, a direct improvement in the quality of your application should be attainable. Essentially, these are the steps:

1. Create the database snapshot before you run your testing:

Click here to view code image

Use [master]goCREATE DATABASE AdventureWorks2012_B4TestON ( NAME = AdventureWorks2012_Data, FILENAME= 'd:\SQLDATA\AdventureWorks2012 ...