If we look at the error in the subject line, it is very clear that a full backup is needed so that the differential backup chain can be initiated. If this happens to a newly created database, then it makes sense and there is no need for me to write a blog. There was an interesting finding about the cause of this error, other than obvious one, so sharing it. Let us see another error related to differential backup.
SQL SERVER – Msg 3101, Level 16 – Exclusive Access Could not be Obtained Because the Database is in Use
This error might have seen by DBAs and they know how to fix it. This blog goes in little details about what are the various options available. Here is the simple reproduction of the error message related to exclusive access.
How to Get Status of Running Backup and Restore in SQL Server? – Interview Question of the Week #113
QHow to Get Status of Running Backup and Restore in SQL Server?
Question: What is a Backup Timeline for Restore Process?
Answer: One of the most popular interview question about Backup and Restore Database process.