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.
1
-
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 BertrandCommented Jun 6, 2013 at 3:31
Add a comment
|
2 Answers
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– swasheckCommented 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.
