• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

SQL Server 2008 R2 - Backing up Databases using compression

 3 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
ekbelt
Basic Member Send Private Message
Posts: 8
Basic Member
9/12/2012 8:14 PM
It seems like I read somewhere (maybe in an older version) that it was not recommended to have database compression turned on when using SQL Server.

We just did an upgrade to SQL Server 2008 R2 and LSF 9.0.1.10. In our current test environment doing a backup on our 240GB database it completes in 6 minutes using the new data compression features in SQL Server 2008 R2... incredible! Without compression it took 36 miuntes, still 4 times faster than our current instance in SQL Server 2005 (takes 2 hrs).

Any one know of any nuances using compression in backups? Just want to double check.

Thanks
Omran
Basic Member Send Private Message
Posts: 4
Basic Member
12/8/2013 3:39 PM
Using backup compression is the way to go with SQL 2K8 , save time and storage space . In our windows/SQL Server environments compression is our standard .

Thanks,
Omran
Jimmy Chiu
Veteran Member Send Private Message
Posts: 641
Veteran Member
12/11/2013 7:20 PM
Been using compression for many years, no problem here.
Alex Tsekhansky
Veteran Member Send Private Message
Posts: 92
Veteran Member
12/12/2013 12:20 AM
Backup with compression worked fine for me in both SQL2008 and SQL2012, and I did numerous backup/restore iterations.