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

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.

| improve this answer | |
  • 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 Balajewicz May 21 at 16:54
  • confirmed, Web Edition does not support compressed backups docs.microsoft.com/en-us/sql/sql-server/… – Greg Balajewicz May 21 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." – David Browne - Microsoft May 21 at 19:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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