Back Up and Restore to a Database and Device

Examples demonstrating how to use a tape drive and a .dat file as the backup and recovery resources.

Using a tape drive

The physical device name TAPE0 replaces the stripe_device variable.

To use the first tape device to back up and load a database:

1> dump database pubs2 to "\\.\TAPE0"
2> go

1> load database pubs2 from "\\.\TAPE0"
2> go

To back up and load the pubs2 database using a .dat file:

1> dump database pubs2 to "d:\backups\backup1.dat"
2> go
1> load database pubs2 from "d:\backups\backup1.dat"
2> go