Leila S on Sat, 26 Jul 2014 04:58:28
We have tens of SQL Server instances and currently they perform regular log backup every 15 minutes.
So far we have been using disk based backups, for example on local disks of servers or shared storage on SAN.
Recently we decided to buy a tape.
My question is that what happens if for example 10 jobs on different servers try to write backup to tape?
Because on disk based backup, the disks of destination will become slow but never reject the backupset. Does the same thing happen for tape or the tape will reject the write operation if requests are too high?
Thanks in advance,
S Guna on Sat, 26 Jul 2014 05:31:05
This depends of the network Speed, Tape writing speed will come down but will not cause any issues.
Normally in general, You can assign a separate network interface for Backup in server or even teaming and separate it with Vlan on switch, connect both Backup devices and backup server on the same Vlan
Backup are kind of Jobs - It runs one by one and its best to be followed in such way