Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Deduplication and storage of backups Expand / Collapse
Author
Message
Posted Friday, October 25, 2013 3:05 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 9:19 PM
Points: 99, Visits: 1,298
While at PASS this year I heard that it was a bad idea to have your backups on deduplicated storage. The reason was that if a single block was lost or corrupted beyond repair, you could loose multiple generations of backups if they all shared it in common. I've tried to search for more information, but I haven't found anything that directly addresses this. When I asked the SAN guy he said not to worry as it did some sort of parity calculation to allow for recovery in case of corruption, and this wasn't a concern. At any rate the SANs are geographically mirrored so that there is at least one other copy. Still, I can easily see a nightmare scenario with a corruption and crash magnified by us being in an auto-tiering configuration.

Anybody have any advice or know of any resources that discuss this? Thanks!
Post #1508605
Posted Saturday, October 26, 2013 4:22 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:53 AM
Points: 13,890, Visits: 28,285
I don't know of a specific resource.

A lot of people are scared (semi-justified) of data deduplication. It's a somewhat new technology and it can be a little sketchy, but I'd say it's no more dangerous to use than any other storage mechanism. Database backups can be corrupted by any number of things, not just dedupe. Dedupe just adds another to the list. So the rules are still the same. Take your backup, test your backup, but, have a second copy off-site on a regular basis to some other storage location.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1508653
Posted Thursday, October 31, 2013 8:23 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 9:19 PM
Points: 99, Visits: 1,298
Thanks! I'm going to see if we can add a third place where we can keep a set of backups as you suggested.
Post #1510206
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse