Use the following example scenarios to create SafeToSQL commands that fit your conversion needs.
Convert an archive with a single backup set
To convert an encrypted archive that contains the pubs database as the single backup set, type the following command at the command prompt:
SafeToSQL "d:\sqlsafe_backup\LT1_pubs_01_enc.safe" -password my_password
The output path and name of the converted file is:
d:\sqlsafe_backup\LT1_pubs_01_enc_1.bak
Convert an archive with multiple backup sets
To convert an archive that contains the northwind database as the second backup set in the archive, type the following command at the command prompt:
SafeToSQL "d:\sqlsafe_backup\LT1_multi_01.safe" -backupset 2
The output path and name of the converted file is:
d:\sqlsafe_backup\LT1_multi_01_2.bak
To list the contents of the archive, type the following command at the command prompt:
SafeToSQL "d:\sqlsafe_backup\LT1_multi_01.safe" –list
Convert an archive saved across multiple files
To convert an archive saved in the directory in two files, type the following command at the command prompt:
SafeToSQL "d:\sqlsafe_backup\pubs_a.safe" –backupfile "d:\sqlsafe_backup\pubs_b.safe"
The output path and names of the converted files are:
d:\sqlsafe_backup\pubs_a_1.bak
d:\sqlsafe_backup\pubs_b_1.bak