What is a deadlock and what is a live lock?

What is a deadlock and what is a live lock?

When two processes, each having a lock on one piece of data, attempt to acquire a lock on the other's piece. Each process would wait indefinitely for the other to release the lock unless one of the user processes is terminated. SQL Server detects deadlocks and terminates one user's process.

A livelock is one, where a request for an exclusive lock is repeatedly denied because a series of overlapping shared locks keeps interfering.A livelock also occurs when read transactions monopolize a table or page, forcing a write transaction to wait indefinitely
What is blocking?
When one connection from an application holds a lock and a second connection requires.......
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........
Post your comment