Snapshot

This Microsoft® Visual C++® console sample demonstrates how to backup or restore the pubs sample database with snapshot by using the Virtual Device Interface feature of Microsoft SQL Server™ 2000. This sample extends the Osimple sample to handle the snapshot extensions. The ability to take or mount snapshots must be implemented before this sample is truly functional.

Default Location

C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Backup\Snapshot

Running the Sample

Open snapshot.dsw in Microsoft® Visual C++® 6.0 and compile this program. Make sure to do the following before compiling:

1. From the Tools menu, choose Options, and then click the Directories tab.
   
   
2. From the Show directories for box, choose Include files and Library files, and ensure that these directories (as appropriate) are included:
   • Include files: C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Include
     
     
   • Library files: C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Lib

To run the sample, open a Command Prompt window, and then change the current directory to where snapshot.exe is located. Run the program by entering "snapshot [b|r]".

The program requires one command line parameter. This parameter can be one of the following:

• b:  perform a backup
  
  
• r:  perform a restore

See Also

Virtual Backup Device Samples