When performing the backup operation on Microsoft SQL Server, below error prompted,
System.Data.SqlClient.SqlError: Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed. (Microsoft.SqlServer.Smo)
Solution
The above error occured is most probably due to there is an existing backup running. You have to wait for the current backup to completely finish first before you can execute a new backup operation. Other criterias below shall be observed as well.
- During the full backup is running, no differential or incremental backups shall be executed.
- One log backup should be running at any point of time.
- While backup is running, you shall not perform any adding, dropping or shrinking activities.
Use below command to determine the history of backup start date/time and finish date/time. It will give you the overview on the backup duration.
select database_name, type, backup_start_date, backup_finish_date
from msdb.dbo.backupset
order by database_name, type, backup_start_date, backup_finish_date
go
See this article from Microsoft for further information.
