Technical FAQs

Ask a Question

Procedure to Extract Data from a Database Snapshot using Vista

Issue
There is a need to query the database to extract data using Vista.

Product Line
SQL Server

Environment
SQL Server Management Studio (SSMS)

Cause
A database snapshot was taken.

NOTE: The procedure on how to create a database snapshot is explained in article FA282751.

Resolution
The procedure to connect to a snapshot is the same as connecting to an archive and explained below:

1. In Designer > QueryServer create a new query module and configure it as shown below.  It is assumed the name of the snapshot is ION_Data_Snap:


2. Create a new Data Log Viewer and configure it as follows:
 


3. Data can be seen up to the time the snapshot was taken:


 
Was this helpful?
What can we do to improve the information ?