I was trying to teach copy-only backups to my students and encountered below 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.
ApexSQL Backup is a tool for Microsoft SQL Server, intended for database backup and restore job management. The application supports all native SQL Server backups (full, differential and transaction log backups), and allows users to easily create, save and manage all backup related jobs. ApexSQL Backup can be used to run, schedule and monitor all backup operations across the domain from a single location.