Osimple

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™ 2000. This sample extends the Simple sample to use an ODBC connection.

Default Location

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

Running the Sample

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