RESTORE WITH STOPAT option allows us to restore our database to a point in time. This gives us the ability…
What is TAIL log backup?
Tail-log backup is introducing in SQL Server 2005. The tail-log backup captures transaction log that were written since the last transaction log backup. If we are going to…
What are the different types of Isolation levels have in SQL Server?
There are 5 type of Isolation levels available in SQL Server – Read Uncommitted: A transaction can read the data…