In some circumstances, we can use compression to decrease the size of backups and the time to complete each backup. I use following command to restore site.

Mount-SPContentDatabase "MyDatabase" -DatabaseServer "MyServer" -WebApplication http://sitename

Is there any impact to the new site or changes due to database compression?

3 Answers 3


I am not seeing any issue, as long as you have healthy backup file at end. SharePoint dont care if you backup file was compressed or not. You have to restore the database and attach it to the SQL then running the mount command will attach it to SharePoint.

You have to always test, if anything on the environment creating any issue.


Backup compression increases CPU usage and this can affect SQL Server concurrent operations.

But there wont be any data loss


I assume you have go through Backup Compression (SQL Server) and from the description , compression significantly increases CPU usage, and the additional CPU consumed by the compression process might adversely impact concurrent operations. Besides , i couldn't see there are any issue if you restore using compression backup .

Your Answer

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

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