Scheduling Backup simultaneously by 2 tools | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Scheduling Backup simultaneously by 2 tools

I am wondering if i schedule the backup by selecting the check box ‘back up as a part of maintainence plan’in maintainence plan wizard and also schedule a third party tool for taking the backup at night ,will these will create any conflict or any performance problem.If yes what are the possible conflicts that might incur.
Yes if the full database backup is running and when you execute the transaction log backup, it may create locks and both the processes will run slow. Its better to take a time for both of the schedules and re-schedule under different timings. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
will it place lock on a single db or on the entire server during full backup of all the dbs on the server
Only on the database which is involved in backup operation. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>