Mthread
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. It demonstrates a multiple stream Backup or Restore from a single process.
Default Location
C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Backup\Mthread
Running the Sample
Open the mthread.dsw in Microsoft Visual C++ 6.0 and compile this program. Make sure to do the following before compiling:
- From the Tools menu, choose Options, and then click the Directories tab.
- 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
- Include files: C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Include
To run the sample, open a Command Prompt window, and then change the current directory to where mthread.exe is located. Run the program by entering "mthread [b|r] [nStreams]".
The program requires two command line parameters. The first parameter can be one of the following:
- b: perform a backup
- r: perform a restore
The second parameter, nStreams, specifies the number of streams to use. It can be an integer from 1 to 32.
Remarks
This sample is designed for use with Mixed Mode security. Comments explaining how to implement Windows Authentication mode are provided in the code.