0

I have sql server 2016 web edition on Windows 2016 server VM.

I want to backup the database, to a folder on a local drive (SSD) - please don't ask why, long story.

Due to the size of the DBs, and comparatively small size of disk, I want to back up to a compressed folder.

What would be the performance implications? Will they be noticeable? (VM with 16 cores, 128GB ram, typically cpu utalization ~ 20%)

Looking for some suggestions based on experience

1 Answer 1

2

Don't backup to a compressed folder. There are supportability problems for SQL Server with compressed folders. See here. Take a compressed backup instead.

3
  • Hmm... I first link seems to talk about storing the database on compressed folder. Does this also imply that the backup it self cannot be stored in compressed folder? And I seem to recall that web edition did not have compressed backups...
    – Greg Bala
    May 21, 2020 at 16:54
  • confirmed, Web Edition does not support compressed backups learn.microsoft.com/en-us/sql/sql-server/…
    – Greg Bala
    May 21, 2020 at 17:34
  • 1
    Looks like the backup is fine "SQL Server backups to compressed volumes can save disk space. However, they may increase CPU usage during the backup operation. We always recommend that you use the BACKUP checksum facilities to help guarantee data integrity." May 21, 2020 at 19:10

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.