SQL Backup question

SQL Backup question

 

  

When running a full database backup, does it create and exclusive locks
on objects in the database or is it mainly shared locks? Reason for
asking is would this cause connectivity errors through ODBC connections
while this is running?


Andrew Theodore
Database Administrator

MS Sql Server LazyDBA home page