Use the Backup Files tab to change the backup files being used for your virtual database. Choosing different backup files allows you to access a different data set, such as a different time period.
When you select a backup file, SQL virtual database opens the file in shared read mode. When Microsoft SQL Server or Idera SQLsafe attempts to append (write) data to this file, the backup operation will fail because the file is locked for read. If your backup policies or jobs are configured to append new data sets to this file , change your backup settings so that a new and unique file is created for each backup.
You can select any full, differential, and transaction log backup files created by Microsoft SQL Server or Idera SQL Safe. For more information, check the supported backup file requirements.
Actions and tasks
Add a backup file to the list
Click Add, to select a backup file to use when creating this virtual database. To add a file, first type the path and filename in the provided field, or browse for the files. You can also use regular expressions to find folders or files that match a naming convention.
If the selected backup file contains encrypted data, you will be prompted to provide the password required to decrypt the file.
If the selected backup file contains data for more than one database, you will be prompted to choose which data set you want.
If the backup was written (or striped) to multiple files, you will need to add each file in the stripe.
Browse for backup files
Click the browse button to find the files you want to use.
Remove a backup file from the list
Click Remove to delete a previously selected backup file from the list of files to use when creating this virtual database.
Specify connection credentials
Click Credentials to specify which Windows account credentials should be used to access the selected files. By default, the SQLvdb Filter Service credentials are used.
Ensure you specify a Windows account that has the appropriate permissions. For more information, check the permissions requirements.
Columns
Created
Provides the date and time when the backup files were created (that is, when the corresponding backup operations were performed).
Database
Provides the name of the database whose data was archived in this backup file.
Data Set
Indicates which data set this backup type is. The selected backup file may contain more than one data set, depending on whether this file was appended with data from multiple backup operations.
Filename
Provides the name of the backup files you selected.
First LSN
Provides the LSN at which each backup starts. For more information, see Microsoft SQL Server Books Online.
Instance
Provides the name of the SQL Server instance hosting the archived database.
Last LSN
Provides the LSN at which each backup ends. For more information, see Microsoft SQL Server Books Online.
Stripe Seq No
Indicates which stripe sequence number the selected file has. If the backup did not use striped files, the sequence number for all selected files will be 1.
Type
Indicates which type of backup was performed when the selected files were created.