Sign up ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

If we enable compression on database backups (because the database backup size is huge) but don't enable it on differential which are relatively small in size, will a restore work? Because the full backup is compressed but the differential isn't compressed.

share|improve this question

migrated from Jun 5 '13 at 18:36

This question came from our site for professional and enthusiast programmers.

While this will work, I would suggest always using compression. What do you gain by NOT doing it some of the time, even if "some of the time" is just on small file sizes? – Aaron Bertrand Jun 6 '13 at 3:31

2 Answers 2

This is really a question for the DBA site but yes, it will work. Compression is transparent when restoring, and the RESTORE command doesn't need any parameter to tell it that a backup is compressed.

Of course you can easily test this yourself.

share|improve this answer
... just make sure that the Full is restored WITH NORECOVERY – swasheck Jun 5 '13 at 20:30

Yes the restore will work just fine. Every edition of SQL Server 2008 and later can restore a compressed backup.

Refer : Backup Compression (SQL Server) for more details.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.