Concurrent backups in SQL Server?
Posted
by Mikey Cee
on Server Fault
See other posts from Server Fault
or by Mikey Cee
Published on 2010-06-11T06:22:52Z
Indexed on
2010/06/11
6:33 UTC
Read the original article
Hit count: 392
sql-server
|backup
We currently have our backups managed by a third party company. There are a bunch of agent jobs created that take full backups (4 times a day) and transaction log backups (4 times an hour).
We now want to manage our backups in house, but don't want to disable the third party's jobs until we are sure that we have everything configured correctly internally
So I am proposing to have a short period (say, a couple of days) where backups are being taken both by the old and the new system.
I am wondering what the ramifications of having these two different systems both manage backups, and the potential pitfalls of having backups taken simultaneously. Is this even supported? If so, and bearing in mind that the system can cope with one backup without any noticeable performance degradation, is it fairly logical to assume that it should be able to cope with two simultaneous backups?
Currently the load on the server is fairly light and it rarely struggles.
Any advice is appreciated
© Server Fault or respective owner