SharePoint 2010 Migration Issue : Exception: 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. ALTER DATABASE statement failed

I have received below error while mounting / attaching content database to SharePoint 2010 site during SharePoint 2010 migration process. after debugging more into issue, I have found there is database backup running at the same time when I have mounted database to SharePoint farm.

Error: [powershell] [SPUpgradeSession] [ERROR] Exception: 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. ALTER DATABASE statement failed.

[powershell] [SPUpgradeSession] [ERROR]:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)

   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

   at Microsoft.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlCommand command)

   at Microsoft.SharePoint.Upgrade.SPContentDatabaseSequence.Upgrade()

   at Microsoft.SharePoint.Upgrade.SPUpgradeSession.Upgrade(Object o, Boolean bRecurse)

Resolution: We have to disabled all the database backup job when we are mounting database. after making sure there is no database backup job running on SharePoint side and SQL Server side - I am successfully able to mount the content database to SharePoint 2010 site.

Every time, I learn new issue and resolution while working with SharePoint 2010 migration.

:)

Reference link: http://msdn.microsoft.com/en-us/library/aa238194%28v=sql.80%29.aspx