What is blocking?

What is blocking?

Blocking is similar to the case of a child holding a ball and all other children waiting to get hold of the same ball.

Blocking in SQL Server means one connection is holding a lock on a resource when other connections are waiting to use the same resource for reading or writing.

Deadlock is different than a Blocking.

We can relate deadlock to the case of two children each having a ball but wants to acquire each other ball.

When two users have locks on separate objects and each process is trying to acquire a lock on the object that the other process has. This situation is Deadlock.
Moving data/databases between servers and databases in SQL Server
BACKUP/RESTORE, Dettach/attach of databases, Replication, DTS, BCP, logshipping.......
Different types of BACKUPs avaialabe in SQL Server
Full database backup. Differential database backup........
What is database replicaion?
The process of copying/moving data between databases on the same or different servers......
Post your comment