Page History

With Virtual Database, manage Virtual Databases from backups created by native SQL Server and SQL Safe Backup. Attach full backups or a series of backups. Virtual Databases behave just like actual live physical databases.  

Virtual Database

SQL Safe integrates with SQL virtual database through the Backup Wizard and Backup Policy Wizard to provide you with a more powerful recovery solution.

SQL virtual database allows you to:

• Recover any object from the backup file without having to restore the database.
• Analyze and report on objects and permissions in backup files without having to restore the database.
• Access backup files as though they were read-only databases.

When creating a backup or backup policy, you can check the option to generate metadata maps for use by InstantRestore and SQL virtual database. This metadata includes data files for each database included in your backup. Generating this metadata is optional; SQL virtual database can attach SQL Safe backup files Safe can mount a Virtual Database without the metadata. However, these data files improve SQL virtual database metadata improves the performance during the creation of the virtual database creation.

If you have SQL virtual database installed, click Attach Virtual Database to launch the SQL virtual database Console. From the Console, you can create virtual databases You can create Virtual Databases from a single full backup file or multiple backup files. You can also create multiple virtual databases Virtual Databases from the same backup file, which allows you to make virtual databases Virtual Databases that include data from different points in time. Once created, the virtual databases Virtual Databases can be fully managed and queried using Microsoft SQL Server Management Studio or another database management tool.

What is

...

a Virtual Database?

SQL virtual database Virtual Database is a powerful one-of-a-kind solution that lets you attach SQL Server backup files and query them like real databases. With its revolutionary, patent-pending technology, you gain instant access to critical data in a backup file without spending the time and storage previously required for restore. In minutes, you can create a virtual database Virtual Database and then use any native SQL Server or third-party tools to query and extract the data you need.

For more information about SQL virtual database, see the  NewtablinkaliasSQL vdb online Helpurlhttp://www.idera.com/help/sqlvdb/1-5/web/default.htmVirtual Database, see working with Virtual Database.

Are there disk space

...

recommendations for the

...

Virtual Database metadata?

Use the following table to help you set aside the appropriate amount of disk space for the virtual database Virtual Database metadata SQL Safe generates. Typically, this metadata requires only a fraction of the disk space consumed by a fully restored backup.

...

...

...