Our customer is considering compressing a very large (6TB+) SQL DB using one of the data compression methods documented at https://learn.microsoft.com/en-us/sql/r ... erver-2016.
What will be the impact to the Veeam backup of the server, SQL log backups, and SQL log truncation routines?
-
TitaniumCoder477
- Veteran
- Posts: 316
- Liked: 48 times
- Joined: Apr 07, 2015 1:53 pm
- Full Name: James Wilmoth
- Location: Kannapolis, North Carolina, USA
- Contact:
-
Dima P.
- Product Manager
- Posts: 14726
- Liked: 1706 times
- Joined: Feb 04, 2013 2:07 pm
- Full Name: Dmitry Popov
- Location: Prague
- Contact:
Re: SQL server data compression
Hello,
We do not expect any issues however there might be performance drawbacks while working with the compressed database. We will double-check and update this thread with the results.
We do not expect any issues however there might be performance drawbacks while working with the compressed database. We will double-check and update this thread with the results.
-
TitaniumCoder477
- Veteran
- Posts: 316
- Liked: 48 times
- Joined: Apr 07, 2015 1:53 pm
- Full Name: James Wilmoth
- Location: Kannapolis, North Carolina, USA
- Contact:
Re: SQL server data compression
Thank you. I look forward to hearing about the test results!
-
Dima P.
- Product Manager
- Posts: 14726
- Liked: 1706 times
- Joined: Feb 04, 2013 2:07 pm
- Full Name: Dmitry Popov
- Location: Prague
- Contact:
Re: SQL server data compression
James, got a configuration that compression does not affect backup, restore and log shipping. Thank you!
-
TitaniumCoder477
- Veteran
- Posts: 316
- Liked: 48 times
- Joined: Apr 07, 2015 1:53 pm
- Full Name: James Wilmoth
- Location: Kannapolis, North Carolina, USA
- Contact:
Re: SQL server data compression
Perfect, thanks!
Who is online
Users browsing this forum: No registered users and 19 guests