Sample Header Ad - 728x90

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