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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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.