Each day we do full backups of all our SQL 2005 databases on Windows 2003 using your SQL Backup 220.127.116.11 product into individual .sqb files using minimum compression (level 1), unencrypted, 2 threads selected under optimization with maximum transfer size set to 1024KB and maximum data block set too 2048KB.
We're very pleased with this tool and haven't touched this process in nearly 2 years - it always creates about 80% compressed backups, on average.
HOWEVER, the few times I've ever attempted to perform a virtual restore, including today, using Virtual Restore v18.104.22.168, it just flat out doesn't work. It certainly doesn't mount to the .sqb files "instantly" with tiny files. but rather crawls and crawls and I see the created .vmdf and .vldf files swell and swell. I eventually give up and cancel.
On a very small database (1.8GB), whose recovery model is simple, the Backup Pro tool creates a tiny .sqb backup (217MB), but the "virtual restore" of this backup took nearly 2 minutes and created a .vmdf of 3.2GB - nearly twice the size of the original .mdf and nearly 15x larger than the .sqb is was supposed to be virtually mounting to.
The "real" .sqb I want to mount to and query virtually is 14GB (original file is 100GB) but, see above, it takes so long and saps so much space, I give up about 1/2 through (which is about 45min later and a .vmdf file size of 80GB and growing with no end in sight - I'm sure it would surpass the size of the original .mdf long before the process ever finished if I were to let it go.
So, what gives? I only read glowing reviews of this product and I've always been happy with the .sqb creation piece, but now I need the virtual mount/restore to work as everybody claims ("instantly" with extremely small .vmdf file sizes).
By the way, it looks like we have HyperBac service version 22.214.171.124 running for the Virtual Restore v126.96.36.199 wizard.