SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Has anyone used Data Domain storage for SQL 2008 backups?


Has anyone used Data Domain storage for SQL 2008 backups?

Author
Message
vikingDBA
vikingDBA
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1214 Visits: 929
Forgot to mention one detail. I copy from server to Data Domain, so the server's NIC is a GB NIC, and I'm slowed by the network link from those servers to the Data Domain location, which is 1/2 mile away at another building. That is definitely something to consider.

I think mine is a fibre link, so I'm probably not losing that much, it is actually pretty quick.

But, I would think I would have a tough time with a 1TB file!

I mitigate my large backups by backing up to the owning server, then copying to the Data Domain. You could go directly to the Data Domain if it was so big you don't have the room to go first to the server. Going directly would then definitely be restricted by the network link speed.

You could do Full backups once a week, with nightly incrementals, that would make it faster, unless a large percentage of the records are modified (directly, with page-splits, etc.).
cmarkowi
cmarkowi
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 12
We've implemented Data Domain backups for our SQL Servers when running in standalone mode. We are able to script it using xp_cmdshell in an agent job so that it mounts the disk, writes the backup, and then unmounts the disk.

The original poster asked about using this with a SQL Server cluster, which it doesn't appear anyone answered. We are looking to do the same, and if anyone has had any experience, please let me know.
Kevin Eckart
Kevin Eckart
SSC-Enthusiastic
SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)

Group: General Forum Members
Points: 165 Visits: 366
We've implemented the data domain with a good amount of success. At first, the SAN admin wanted to remove tlog and full backup scheduling from SQL Agent and use the EMC Networker software to control this. After some questions regarding the viability of the backups in the event of Networker issues, we decided that adding another layer of complexity to the backups wasnt ideal for us. We implemented the data domain by hanging a windows file share off of the appliance so that the SQL server would see if just like any other file share. Since we were already using Ola Hallengren's maintenance scripts to backup our databases, all we had to do was change the directory the script was pointing to.
shew
shew
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2498 Visits: 954
cmarkowi (5/8/2013)
The original poster asked about using this with a SQL Server cluster, which it doesn't appear anyone answered. We are looking to do the same, and if anyone has had any experience, please let me know.


When I posted the original message, I didn't know much about Data Domain. Since that time, we have implemented Data Domain for all of our cluster and standalone backups. Initially, we had lots of vendor problems in getting security implemented using Active Directory. However, once we finally got past that (which took literally months), we've had to revert back to file share backups from time to time when Data Domain patches had issues. (It's a site standard to patch everything often and quickly.) However, Data Domain has been reliable for the last 6 months or so.

Instead of using xp_cmdshell (which has security issues), we chose to use a PowerShell script (launched by Task Scheduler) which calls the TSQL "backup database" command using sqlcmd.exe. (By the way, we had issues with the PowerShell 2.0 invoke-command verb because we could not trap backup errors reliably using it. "$?" seems to trap errors from sqlcmd.exe reliably.)

We have the same script scheduled on all nodes in the cluster, and the script checks to see if a given instance is running on that particular node before it backs it up. That way, we avoid backing up the same instance multiple times from Task Scheduler.

We have over 20 instances writing their backups to Data Domain. Most instances execute a full backup once a week and hourly incremental backups throughout the week. We also have a script that tests the backups (via PowerShell, sqlcmd.exe, and TSQL "restore database") from each instance once a week. A backup set often has 80+ transaction logs, and we have not had any significant issues with restores. When we have an backup or restore issue, it is usually caused by a network glitch.

In our experience, Windows file share performance is faster than Data Domain performance, which makes sense because file shares are not performing de-duplication, but Data Domain makes sense for our configuration.

By the way, we use UNC (\\data_domain_server_name\share_name) in our SQL Server backups, rather than mapped drive letters. We had all sorts of headache trying to use mapped drive letters, but UNC fixed that fairly reliably.



epetro
epetro
Valued Member
Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)

Group: General Forum Members
Points: 50 Visits: 131
We are looking at Data Domain to assist us in our growing disk space issues.
I read this forum without seeing code provided by our contact (reference to nsrsqlsv.exe).
I don't know if the configuration is different, but I'm trying to get something like this going:

declare @sname varchar(25),@dname varchar(25),@stmt varchar(1000)
select @sname='SERVER1',@dname='DATABASE1'
select @stmt='nsrsqlsv.exe ' /*backup executable*/
+'-s server.domain.net ' /*networker server*/
+'-c '+@sname+'.domain.net ' /*client server*/
+'-A '+@sname+'.domain.net ' /*virtual-server, for clusters*/
+'-l full ' /*level*/
+'-S 10 ' /*number of stripes (threads) */
+'-a "device interface=data domain" ' /*duplication node*/
+'-b "ourPool" ' /*backup pool*/
+'-g "ourGroup" ' /*group*/
+'"MSSQL:'+@dname+'"' /*database name*/
print @stmt
exec xp_cmdshell @stmt



I'll try to remember to repost when we get this working. We have a trial of NetWorker (they don't do that very often).
gary1
gary1
SSCarpal Tunnel
SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)

Group: General Forum Members
Points: 4746 Visits: 2254
Hi Old Hand,

can you please share the power shell backup and restore scripts. I'm struggling to backup to Data Domain.

Thanks
Kevin Eckart
Kevin Eckart
SSC-Enthusiastic
SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)

Group: General Forum Members
Points: 165 Visits: 366
We're using Ola Hallengren's scripts to backup to the data domain. We are backing up to a file share on the DD and not using Networker. His scripts can be found here
gary1
gary1
SSCarpal Tunnel
SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)

Group: General Forum Members
Points: 4746 Visits: 2254
Hi Kevin,

EMC Data Domain, has ddbmsqlsv.exe. How you are incorporating this exe in Ola's backup script? Can you please advise.


ddbmsqlsv.exe -c STAGEVS.abc.com -A STAGEVS.abc.com -S 2 -l full -N "DDBackup_DB1" -y "01/09/2015 10:37:34" -a "NSR_DFA_SI=TRUE" -a "NSR_DFA_SI_USE_DD=TRUE" -a "NSR_DFA_SI_DD_HOST=mrydd.abc.com" -a "NSR_DFA_SI_DD_USER=ddboost" -a "NSR_DFA_SI_DEVICE_PATH=/sql_backup" "MSSQLBigGrinB1"
Kevin Eckart
Kevin Eckart
SSC-Enthusiastic
SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)

Group: General Forum Members
Points: 165 Visits: 366
We aren't. We're using SQL Agent to run Ola's jobs to backup to a file share. That file share is connected to the Data Domain.
gary1
gary1
SSCarpal Tunnel
SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)

Group: General Forum Members
Points: 4746 Visits: 2254
So, do we need give read/write permissions to sql service account in Data Domain file share? can you please advise?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search