Concurrent backups in SQL Server?
- by Mikey Cee
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