Virtual Backup Device Samples

Transact-SQL Samples

Samples

Virtual Backup Device Samples

The following samples illustrate Microsoft® SQL Server™ 2000 Virtual Backup Device application development.

Sample Description
Mprocess Visual C++ sample. Demonstrates how to backup or restore the pubs sample database by using the Virtual Device Interface feature of SQL Server 2000.
Mthread Visual C++ sample. Demonstrates how to backup or restore the pubs sample database by using the Virtual Device Interface feature of SQL Server 2000.
Osimple Visual C++ sample. Demonstrates how to backup or restore the pubs sample database by using the Virtual Device Interface feature of SQL Server 2000 with ODBC.
Simple Visual C++ sample. Demonstrates how to backup or restore the pubs sample database by using the Virtual Device Interface feature of SQL Server 2000.
Snapshot Visual C++ sample. Demonstrates how to backup or restore the pubs sample database with snapshot by using the Virtual Device Interface feature of SQL Server 2000, and handles snapshot extensions.
To install the samples during SQL Server installation
  1. On the Setup Type page, select Custom.

  2. On the Select Components page, under Components, select Development Tools.

  3. Under Sub-Components, select Backup/Restore API.

Samples are installed as a self-extracting file. To extract the samples, double-click Unzip_backup.exe, located at
C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Backup.

Note  The SQL Server 2000 Virtual Backup Device Specification, which contains detailed information about Virtual Backup Device application development, is also installed as Vbackup.chm.

Prerequisites

C++ samples require Microsoft Visual C++ version 6.0.

See Also

Samples