SQL Virtual Database – Idera
We know that DBA’s are often asked to restore a backup in order to recover objects or data, compare two systems, or run a report.
Today, the only way to do this is to restore the database, a time and storage consuming activity.
SQL virtual database creates a ‘virtual database’ that appears to SQL Server and third-party applications like an actual database providing access to the data directly without a restore. This greatly reduces the time for data recovery while also increasing productivity and reducing resource requirements.
Key Benefits of SQL Virtual Database
- Reduces time and space requirements: SQL virtual database lets DBAs get instant-access to data in full, differential and log backup files without requiring the additional time or space to perform a database restore.
- Improves DBA productivity: DBAs continue to use all the tools they already know to access data in the virtual database. This greatly improves productivity and allows them to focus on other more important activities.
- Enables object level recovery: Provides unparalleled object level recovery capabilities for both Idera SQL safe backup and native SQL Server backup fi les. Obtain access to all schema, objects and data using any language or application.
- Offers easy installation and use: SQL virtual database can be installed and confi gured very quickly, typically in less than 15 minutes.
SQL Virtual Database Technical Features
- Console: Console allows virtual databases to be quickly and easily be added, edited, or removed.
- Point-in-time selection: Provide point-in-time selection and recovery allowing granular control over the state of the information displayed in the virtual database.
- Native SQL Server and third-party tool access: Use existing SQL Server tools such as SQL Server Management Studio and 3rd party tools to interact with the new virtual database.
- No impact to production systems: Quickly and easily install onto a single non-critical system and attach all virtual databases to a single SQL Server instance.
- SQL safe backup and SQL Server Backup File Support: Provide access to all data from within SQL safe 5.0+ backup and native SQL Server 2000 and 2005 backup files.
