Can anyone tell me if there is a way to force delete documents from the recycle bin? I have 2 pdf files that I am unable to delete from the End User Recycle Bin. I get the below log errors when I try. System.Data.SqlClient.SqlException: SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:10770048; actual 0:0). It occurred during a read of page (1:10770048) in database ID 37 at offset 0x0000148ad00000 in file 'G:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\WSS_Content_Records.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.Sq... 06/03/2010 11:56:53.49* w3wp.exe (0x0D18) 0x030C Windows SharePoint Services Database 880i High ...lClient.SqlInternalConnection.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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, ... 06/03/2010 11:56:53.49* w3wp.exe (0x0D18) 0x030C Windows SharePoint Services Database 880i High ...DbAsyncResult result) 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) 06/03/2010 11:56:53.49 w3wp.exe (0x0D18) 0x030C Windows SharePoint Services Database 880j High SqlError: 'SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:10770048; actual 0:0). It occurred during a read of page (1:10770048) in database ID 37 at offset 0x0000148ad00000 in file 'G:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\WSS_Content_Records.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.' Source: '.Net SqlClient Data Provider' Number: 824 State: 2 Class: 24 Procedure: 'proc_DeleteRecycleBinItem' LineNumber: 956 Server: 'ASTARINT... 06/03/2010 11:56:53.49* w3wp.exe (0x0D18) 0x030C Windows SharePoint Services Database 880j High ...RADB' 06/03/2010 11:56:53.49 w3wp.exe (0x0D18) 0x030C Windows SharePoint Services Database 5586 Critical Unknown SQL Exception 824 occured. Additional error information from SQL Server is included below. SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:10770048; actual 0:0). It occurred during a read of page (1:10770048) in database ID 37 at offset 0x0000148ad00000 in file 'G:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\WSS_Content_Records.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. 06/03/2010 11:56:53.51 w3wp.exe (0x0D18) 0x030C Windows SharePoint Services Database 880k High at Microsoft.SharePoint.SPRecycleBinUtility.DeleteHelper(SPSite site, SPWeb web, Guid[] ids, Int32 startIndex, Int32 endIndex, Boolean ignoreNotFound, Int32& returnValue, Guid& failedItem) at Microsoft.SharePoint.SPRecycleBinUtility.DeleteMultiple(SPSite site, SPWeb web, Guid[] ids, Boolean ignoreNotFound, Int32& returnValue, Guid& failedItem) at Microsoft.SharePoint.SPRecycleBinUtility.Delete(SPSite site, SPWeb web, Guid[] ids, Boolean ignoreNotFound, Int32& returnValue, Guid& failedItem) at Microsoft.SharePoint.SPRecycleBinItemCollection.DeleteCore(Guid[] ids, Boolean ignoreNotFound) at Microsoft.SharePoint.SPRecycleBinItemCollection.Delete(Guid[] ids) at Microsoft.SharePoint.ApplicationPages.RecycleBinPage.ProcessAction(String action, String guidString) at Mic... 06/03/2010 11:56:53.51* w3wp.exe (0x0D18) 0x030C Windows SharePoint Services Database 880k High ...rosoft.SharePoint.ApplicationPages.RecycleBinPage.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP._layouts_adminrecyclebin_aspx.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& co... 06/03/2010 11:56:53.51* w3wp.exe (0x0D18) 0x030C Windows SharePoint Services Database 880k High ...mpletedSynchronously) at System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception error) at System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) at System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr) at System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType) 06/03/2010 11:56:53.51 w3wp.exe (0x0D18) 0x030C Windows SharePoint Services Database 880l High ConnectionString: 'Data Source=ASTARINTRADB;Initial Catalog=WSS_Content_Records;Integrated Security=True;Enlist=False;Connect Timeout=15' ConnectionState: Closed ConnectionTimeout: 15 06/03/2010 11:56:53.51 w3wp.exe (0x0D18) 0x030C Windows SharePoint Services Database 880m High SqlCommand: 'SET @DeleteTransactionId = '5a042d7c-c2d5-42ed-bf17-e636da9790a8'; EXEC @Ret = proc_DeleteRecycleBinItem @SiteId, @WebId, @UserId, @DeleteTransactionId; IF @Ret <> 0 GOTO cleanup;SET @DeleteTransactionId = '0bcdc760-3274-45ba-8f6d-50dca8c586ff'; EXEC @Ret = proc_DeleteRecycleBinItem @SiteId, @WebId, @UserId, @DeleteTransactionId; IF @Ret <> 0 GOTO cleanup;SET @Ret = 0; cleanup: ' CommandType: Text CommandTimeout: 0 Parameter: '@Ret' Type: Int Size: 0 Direction: Output Value: '' Parameter: '@DeleteTransactionId' Type: UniqueIdentifier Size: 0 Direction: Output Value: '' Parameter: '@SiteId' Type: UniqueIdentifier Size: 0 Direction: Input Value: '04e7acd5-da9c-4621-83c9-f8b1c1de07a3' Parameter: '@WebId' Type: UniqueIdentifier Size: 0 Direction: Input Value:... 06/03/2010 11:56:53.51* w3wp.exe (0x0D18) 0x030C Windows SharePoint Services Database 880m High ... '00000000-0000-0000-0000-000000000000' Parameter: '@UserId' Type: Int Size: 0 Direction: Input Value: '0' 06/03/2010 11:56:53.51 w3wp.exe (0x0D18) 0x030C Windows SharePoint Services General 8dzz High Exception Type: System.Data.SqlClient.SqlException Exception Message: SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:10770048; actual 0:0). It occurred during a read of page (1:10770048) in database ID 37 at offset 0x0000148ad00000 in file 'G:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\WSS_Content_Records.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. 06/03/2010 11:57:02.04 OWSTIMER.EXE (0x0828) 0x0844 Windows SharePoint Services

Try the code approach given here with a simple Console Application: http://social.msdn.microsoft.com/Forums/en/sharepointdevelopment/thread/3c9d4c1e-9efc-4d8d-9c78-92a70cbc0021BR, PM

Try the code approach given here with a simple Console Application: http://social.msdn.microsoft.com/Forums/en/sharepointdevelopment/thread/3c9d4c1e-9efc-4d8d-9c78-92a70cbc0021 BR, PM Prasanjit, That was a good idea, but I still get the same SQL error when running the console application.