This is the strangest error message ever from stsadm. I am just trying export a site. Some other sites works fine in the same content db. Any ideas? Error: Transaction (Process ID 697) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. 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.SqlDataReader.HasMoreRows() at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.LoadAdapter.FillFromReader(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.DataSet.Load(IDataReader reader, LoadOption loadOption, FillErrorEventHandler errorHandler, DataTable[] tables) at System.Data.DataSet.Load(IDataReader reader, LoadOption loadOption, String[] tables) at Microsoft.SharePoint.Deployment.ListItemObjectHelper.GetNextBatch() at Microsoft.SharePoint.Deployment.ObjectHelper.RetrieveDataFromDatabase(ExportObject exportObject)

Hi:I never came across this before but it seems that the site's content db which you are trying to export using stsadm command is being utilised by some another process. Are you using that site in anyways? Do your site has custom code running for web-parts or event receivers etc? They may cause the deadlocks..Best Regards, Mukesh Giri Sr.System Executive

Thanks for response Mukesh, no I don't have any custom code.

I see the same issue and have been encountering it for some time. Not sure of a way to prevent it, but I think I remember reading somewhere it is part of and upgrade to SQL. If anyone has ideas on how to prevent it, please let me know. I did find that if I change the URL first, it happens much less (example STSADM renameweb, export, then rename web back to correct name).