Does compressing indexes reduce the size of already compressed backups?
4
votes
1
answer
600
views
I use backup compression everywhere. Recently, I discovered that my backups were getting a little too big. I decided to fix this by compressing the indexes in the database (typically
PAGE
compression). The database got much smaller. But to my surprise, the full backups didn't get smaller!
Is this expected behaviour?
Asked by J. Mini
(1235 rep)
Oct 16, 2024, 08:43 AM
Last activity: Oct 16, 2024, 10:31 AM
Last activity: Oct 16, 2024, 10:31 AM