SQL Virtual Restore presents a new, smart and safe approach to object level recovery, backup verification, and fine-tuning schema, data and configuration changes in environments where storage space is at a premium. With full support for read and write operations, the databases you mount with SQL Virtual Restore behave in every way like a live, fully functional database and are ideal for efficient database development and testing work. The near-zero additional storage footprint of the databases you mount with SQL Virtual Restore enables you to replicate your full production environment - but with significant storage and time savings.
SQL Virtual Restore is also available as part of SQL DBA Bundle.
Features
- Rapid restore
Turn your backup into a fully functional, live database – without a physical restore – and get quick and easy access to your data. Mounting your backup as a live database carries a near-zero additional storage footprint and is considerably faster than a full restore.
- Multiple backup types
Just point SQL Virtual Restore at full, differential or transaction log backups created with native SQL Server, SQL Backup Pro (version 6), or SQL HyperBac.
- Support for read/write operations
Behaving just like a normal, live database, databases mounted with SQL Virtual Restore are ideal for development and test work in environments where storage space is at a premium.
- Smart object level recovery
Gain access to full, transactionally consistent data, with all objects visible and available, so you can run recovery operations from your point-in-time backup.
- Easy backup verification
The database you mount with SQL Virtual Restore behaves like a normal live database, meaning that a DBCC CHECKDB command will fully verify the integrity of your backup file.
- Flexible data access
SQL Virtual Restore supports any data access method, including SQL Server Management Studio, ADO.NET and SQL Query Analyser.
- SQL Virtual Restore Wizard
Use SQL Virtual Restore via T-SQL's native RESTORE DATABASE and RESTORE LOG commands, or use the SQL Virtual Restore wizard to mount your backups in just four steps.
- Declarative Referential Integrity
SQL Virtual Restore will enforce the referential integrity of your database, so data that is not compliant with your business rules cannot be inserted into your virtually restored database.
- Powered by HyperBac
SQL Virtual Restore uses the original HyperBac technology.
About Red Gate Software
Red Gate Software counts Microsoft, HP, Sage, Bank of America, AT&T, the US Treasury and over 9,000 other leading organizations as customers of its software development tools. There are over 100,000 Microsoft technology DBAs, developers and testers currently using Red Gate products. The company believes that by producing simple tools that solve the technical problems of Microsoft technology professionals it will continue to add value to the software development community. Therefore, it does not sell 'integrated' software with large, often unnecessary, feature sets. Red Gate was founded in 1999 and moved to Cambridge at the start of the year 2000. It is a privately owned and managed company. Its focus is on Microsoft technologies. Red Gate was chosen as a Global Gold Launch Partner for Microsoft Visual Studio .NET and are a Visual Studio Integration Program partner.
