Page tree

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” –additionalfile “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