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.

  • 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? Jun 6, 2013 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.

  • ... just make sure that the Full is restored WITH NORECOVERY
    – swasheck
    Jun 5, 2013 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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.