Could affect disk i/o, cpu and memory use

-----Original Message-----
From: Theodore Andrew
[mailto:mssqldba-ezmlmshield-x52314469.[Email address protected]
Sent: Thursday, June 28, 2007 2:47 PM
To: LazyDBA Discussion
Subject: 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


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page