Getting started - SQL Storage Compress

SQL Storage Compress enables you to run fully functional SQL Server databases from compressed database files, saving you disk space, and improving transaction throughput with reduced I/O.

You can work with compressed SQL Server databases using the same tools and scripts you already use with standard SQL Server databases (for example, using SQL Server Management Studio).

You create compressed SQL Server databases with SQL Storage Compress by restoring from backup files in these formats: SQL Server (native), SQL HyperBac, and SQL Backup Pro. Backup files created by other tools (for example, Quest LiteSpeed™) are also supported, provided any required 3rd-party backup software components are also installed.

Supported platforms

Microsoft SQL Server versions:

2000 (SP3 or later), 2005, 2008, 2008 R2
Developer, Standard and Enterprise editions (32-bit and 64-bit)

Windows operating systems:

Windows Server 2003 (SP1 and SP2), 2003 R2, 2008, 2008 R2
- Standard and Enterprise editions; 32-bit and 64-bit
2000 with SP4 (Advanced Server, Server, and Professional editions), XP Professional with SP1, SP2 and SP3, Vista and Windows 7
- 32-bit and 64-bit

Worked examples

You can use a wizard to create compressed databases from these types of backup file: SQL Server (native), SQL HyperBac, SQL Backup Pro, and Quest LiteSpeed™ (unencrypted). Go to worked examples

You can also write your own T-SQL scripts to create compressed databases from backup files in any format, including those created by other 3rd-party backup applications. Go to worked examples

Related products

SQL Virtual Restore enables you to mount a backup file as a fully functional database, giving you access to the backed-up data. Unlike a normal restore operation, almost no additional disk space is required. You can use SQL Virtual Restore to verify your backup files using DBCC CHECKDB, and for object level recovery that maintains declarative referential integrity.