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

SharePoint 2007 site templates not appearing into SharePoint 2010

I have came across situation in which after MOSS 2007 to SharePoint 2010 migration – site templates are not appearing while creating new site in 2010, then I have figured out that .STP (site template file) concept has been removed in SharePoint 2010, so for saving any site template in 2010 we need to save file as .WSP which will automatically save solution to solution gallery page and then we need to activate that site template to be appear while creating new sites in SharePoint 2010.

Here are some reference link which talks about how to create site templates in 2010

http://www.learningsharepoint.com/2010/06/20/moving-site-template-stp-files-to-sharepoint-2010/

http://collab.rdacorp.com/2010/01/sharepoint-2010-custom-site-template.html

Insufficient SQL database permissions for user on SQL Server instance, the EXECUTE permission was denied on the object proc_GetProductVersions

I was getting ‘Insufficient SQL database permission’ issue in event viewer and 14 hive log file if I create any sub-site into 2010 environment. from user interface I didn’t see any errors.

Here is alternative option for this issue by granting permission into SQL server database.

Resolution links:

http://sharepointsoldiers.wordpress.com/2011/10/09/insufficient-database-permissions-proc_getproductversions-eventid-5214/

http://sajiviswam.wordpress.com/2011/05/24/the-execute-permission-was-denied-on-the-object-proc_getproductversions-insufficient-sql-database-permissions-for-user/