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: 394

Filed under:
|

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

Related posts about sql-server

Related posts about backup