Pages

Tuesday, October 23, 2012

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.

:)

No comments:

Post a Comment