March 15, 2012 at 11:06 am
Hi,
We have Share Point 2010 databases on SQL Server 2008R2. The full backup of all content databases is taking 12 hours (total data size 1.5 TB)
I sthere any option in sql sevrer to configure backups to use separate Network card to decrase the Backup time?
Also is there any option to have separate Network card for Log shipping traffic?
Thanks
March 15, 2012 at 11:12 am
If your backup Server is on a different VLAN to the SQL Server, you could then add another NIC card on the SQL Server and give it an IP Address in the same VLAN as the Backup Server.
The backup traffic would then go out over that NIC card
March 15, 2012 at 11:30 am
We have 2 node a/p cluster set up for SQL Server 2008 R2.
The backup goes to Shared Clustred Drive. In this case, can we set up separate network card for Backups and also for log shipping?
March 15, 2012 at 12:20 pm
SQL Server per se isn't going to care which card is used to access the drive. It frankly doesn't actually care whether the drive being used is local or not (it only cares to know if the user running the backup has the permission to write to the destination wherever that happens to be). If it is remote - it uses the Windows network routing tables to determine which card gets used to talk to a given machine.
In order to make SQL do what you wish, you need to use Windows-multi-homing or multiple VLANs on separate subnets (i.e. what Beetlejuice is describing) to do it.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
March 15, 2012 at 1:36 pm
Matt,
In real world, if the database size 2 TB, how to backup that?
Full backup may take 1 day or 2..I don't think people do that way..
Please advise
March 15, 2012 at 1:49 pm
depends on the throughput of the server and how fast it can write to the disks. As to how long it takes. You could look at 3rd party tools to backup, litespeed from quest is one which can speed up backups.
you could do a weekly full, with daily diffs and tx logs every X minutes
March 15, 2012 at 3:27 pm
gmamata7 (3/15/2012)
Hi,We have Share Point 2010 databases on SQL Server 2008R2. The full backup of all content databases is taking 12 hours (total data size 1.5 TB)
I sthere any option in sql sevrer to configure backups to use separate Network card to decrase the Backup time?
Also is there any option to have separate Network card for Log shipping traffic?
Thanks
are you backing up across the network?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 15, 2012 at 3:44 pm
gmamata7 (3/15/2012)
Matt,In real world, if the database size 2 TB, how to backup that?
Full backup may take 1 day or 2..I don't think people do that way..
Please advise
I am not the best to ask for tuning backup speed. I am more on the design side than administration (I'm an architect). I will defer to the people with more experience who will no doubt come by to comment shortly. That said - our folks here use a lot of SAN-to-SAN tools to perform backups and/or in memory snapshots of VERY large DB's.
On your setup, it is hard to gauge, but if I had to guess - it kind of sounds like you're performing the backup over a "regular" NIC, rather than backing up to a SAN drive directly. If you were using a SAN-connected drive to perform that backup - it should not take anywhere near that kind of time.
Even without a SAN - if you were to back up to a local drive then COPY the output file, you'd save yourself a lot of time (the backup writes, then reads and verifies, so the traffic is a LOT higher than a single copy of the DB). Especially if you use tools that backup and compress at the same time (like the RedGate tools offer), the file being moved would be a LOT smaller.
The last comment I'd make is - do you need a full backup every day, or could you get away with something like differential backups most days. Simply figuring out which DB's you have to fully backup daily, and which can benefit from other options should help you with your window.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
March 19, 2012 at 10:27 am
the backup drive is Clustered Shared drive sitting on SAN. So in that case, we do not need any separate NIC as the backup directly writing to disk on SAN? Please clarify me..thanks
March 19, 2012 at 11:05 am
gmamata7 (3/19/2012)
the backup drive is Clustered Shared drive sitting on SAN. So in that case, we do not need any separate NIC as the backup directly writing to disk on SAN? Please clarify me..thanks
can you confirm the connection topolgy between the server and network storage, FC, iSCSI, etc
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 19, 2012 at 11:11 am
What I would try (not that its exactly correct) is writing the backup locally (I know its huge) and use Backup Compression. Then have a separate step move the file to the other location. Have your network engineers use the backplane of the switches to move it. This should lessen the amount of data moving (compressed locally), and speed the transmission of what data you are moving.
March 19, 2012 at 11:15 am
The backup drive is a local SAN presented drive
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 19, 2012 at 11:51 am
can you confirm the connection topolgy between the server and network storage, FC, iSCSI, etc
it's FC.
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply