Restore Only Data in SQL Server

One of the challenges that many SQL Server DBAs face is the restoration of large or VLDBs to a different environment from which they were originally backed up.

Using SQL Server natively or many third-party database restore solutions, the restore process will always create the data and log devices/files to the same size as they were on the source database. This can be an issue if the database is quite large or contains a large amount of unallocated space (which many databases do for growth and capacity planning).

Until HyperBac Online entered the market, just restoring the data was not possible without the creation of the data and log devices entirely to their original size. HyperBac Online makes this a possibility, and moreover allows you to restore only a compressed image of the data.

A practical scenario would be as described below: