A SQL Backup Operation Fails While the Database is Being Used
Article ID: SQL0009 A SQL backup operation fails because the SQL Server has concurrency restrictions during backup operations.
SQL backup operation fails because the database is being created or deleted or the backup operation has timed out.
SQL backup operation fails because the SQL Server restricts the following concurrent operations during a backup operation:
- Creating or deleting database files
- Creating an index
- Performing a non-logged job
- Shrinking a database
Avoid running concurrent SQL Server restricted operations. Wait for the first conflicting operation to finish before starting the backup operation.