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