SQL dumps to Data Domain after failover to DR

Question

We have a Data Domain set up to receive dumps from SQL to CIFS.  They dump directly to the DD in our main Data Center.  The data is then replicated to a matching DD at our DR site.  I was recently asked by my bosses, 'If we lose the primary data center and have to fail over to the DR, are we still able to do dumps?'  My answer was technically no.  I know I could set up matching shares on the DD at the DR site, and if we ever had to fail over, the SQL team would have to point all of their dumps to go to that one, but then when we failed back, that data would kind of be orphaned.  Their main concern was with the hourly SQL transaction logs that we dump from our SAP environment.  I am also concerned with what would happen with my Avamar backups as well. I guess my question is, is there a clean way to fail over backups to a DR site in the case of an extended emergency?

paul_aviles · Answer

You need to take into context that the DD units is not really a multi purpose File Server, but a way to facilitate backups. You can however drive the logic from the SQL server itself if you check if the share exist first and if not use the alternate.

I don't know SQL script, perhaps you can ask a DBA to do it and modify something like this:

http://beyondrelational.com/modules/30/scripts/485/scripts/15042/backup-database-across-the-network.aspx

Data Domain

Was this post helpful?