Does SQL Backup hold locks during backup?

dmandelldmandell Posts: 2
edited March 20, 2008 7:21PM in SQL Backup Previous Versions
With the regular SQL Server backup procedure locks are not held on the database during backup, we wanted to make sure before we tried using Red Gate's SQL Backup software that this was the case, in order to avoid any potential performance issues with our application during backups.

I tried searching your knowledge base and this forum and came up empty, sorry if this has been answered prevoiusly.

Comments

  • peteypetey Posts: 2,358 New member
    SQL Backup does not hold any additional locks compared to regular SQL Server backups. See this documentfor details on what actually happens during a SQL Backup backup/restore.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.