Backup of SQL server fails with V-79-65323-3023 - Backup and file manipulation operations (such as ALTER DATABASE ADD FILE) on a database must be serialized.

book

Article ID: 100028968

calendar_today

Updated On:

Description

Error Message

V-79-65323-3023 - Backup and file manipulation operations (such as ALTER DATABASE ADD FILE) on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed.

 

Cause

One or more backup or other operations may be pending for the database(s) in SQL which prevents any backup or file manipulation operations.


 

Resolution

Check the status of the database in SQL to see if it is in a state such as "Restoring" and if so, allow time for the current operation to complete before attempting another backup.

Alternately perform any of the following:

  • Cancel the pending operation against the database
  • Bring the database offline and back online
  • Remove the database from the backup selections

Issue/Introduction

SQL Server backups fail with an error indicating operations must be serialized.

Additional Information

UMI: V-79-65323-3023