Simple

This Microsoft® Visual C++® console sample demonstrates how to backup or restore the pubs sample database by using the Virtual Device Interface feature of Microsoft® SQL Server™.

Default Location

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

Running the Sample

Open the simple.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 simple.exe is located. Run the program by entering "simple [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

Remarks

This sample is designed for use with Mixed Mode security. Comments explaining how to implement Windows Authentication mode are provided in the code.

See Also

Virtual Backup Device Samples