Sample Header Ad - 728x90

Why does data compression not affect backups?

0 votes
1 answer
217 views
[The documentation is very clear on this point](https://learn.microsoft.com/en-us/sql/relational-databases/data-compression/data-compression?view=sql-server-ver16#effect-on-other-sql-server-components) > Compression doesn't affect backup and restore. but how is that possible? Surely, if my table is smaller (due to compression), then that should have some impact on backups/restores? If my table is smaller, then it should load faster. If my table needs some decompressing, then that should make it takes longer. Either way, I just can't believe that data compression **does absolutely nothing** to backups and restores. What am I missing?
Asked by J. Mini (1235 rep)
Apr 15, 2024, 07:25 PM
Last activity: Apr 16, 2024, 11:21 AM