Situation: My coworker and I recently setup a server for Sharepoint Services 3.0, and started building a collection of sites. Today, I was copying the contents of a document library from one library on one subsite to a library on another, using the explorer view. It was alot of files, the transfer started successfully, but when I checked back later the entire site collection was gone. In the log files @C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\LOGS 03/30/2010 13:17:52.00 w3wp.exe (0x0C54) 0x07E4 Windows SharePoint Services Database 6f8g Unexpected Unexpected query execution failure, error code 266. Additional error information from SQL Server is included below. "Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 0, current count = 1." Query text (if available): "DECLARE @@S uniqueidentifier; DECLARE @@W uniqueidentifier; DECLARE @@DocId uniqueidentifier; DECLARE @@DoclibRowId int; DECLARE @@Level tinyint; DECLARE @@DocUIVersion int;DECLARE @@IsCurrentVersion bit; DECLARE @@iRet int; DECLARE @DN nvarchar(256); DECLARE @LN nvarchar(128); DECLARE @FU nvarchar(260); SET @DN=N'CSO3/Shared Documents/Workforce Management/Scheduling/Paid Time Off Procedure - WFM1107';SET @LN=N'CSG Paid Time Off Training.doc';SET @FU=N'CSO3/Shared Documents/Workforce Management/Scheduling/Pa... 03/30/2010 13:17:52.00* w3wp.exe (0x0C54) 0x07E4 Windows SharePoint Services Database 6f8g Unexpected ...id Time Off Procedure - WFM1107/CSG Paid Time Off Training.doc';SET @@S='FFE91CF9-E509-482F-AD04-A5339B069306';SET @@W='A492F5D2-A42A-4605-A27A-ECCFA7F3B2B1';SET @@DocUIVersion = 512;BEGIN TRAN; IF @@iRet <> 0 GOTO done; SET @@Level =1; EXEC @@iRet = proc_UpdateDocument @@S, @@W, @DN, @LN, ?, ?,12882944,992,0,2,332,NULL,NULL,0,0,0,0,7,0,2097154,1,-2,NULL,1,0,NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,@@DocId OUTPUT, @@Level OUTPUT , @@DoclibRowId OUTPUT,? OUTPUT,? OUTPUT,? OUTPUT, ?,? OUTPUT; IF @@iRet <> 0 GOTO done; EXEC proc_DirtyDependents @@S,1,@FU; EXEC @@iRet = proc_UpdateListItem @WebId='A492F5D2-A42A-4605-A27A-ECCFA7F3B2B1',@SiteId='FFE91CF9-E509-482F-AD04-A5339B069306',@ListID='1E899D76-82F6-4815-8A2C-485D3DE04E19',@ItemId=@@DoclibRowId, @NewUIVersion = @@DocUIVersion OUTPUT,... 03/30/2010 13:17:52.00* w3wp.exe (0x0C54) 0x07E4 Windows SharePoint Services Database 6f8g Unexpected ...@RowOrdinal=0,@ReturnRowset=1,@Size=NULL,@ItemName=N'CSG Paid Time Off Training.doc',@IsDocLib=1,@MajorVersionsLimit=0,@MajorMinorVersionsLimit=0,@UserId=7,@Level=@@Level, @TimeNow='20100330 18:17:51', @tp_ContentTypeId = ?,@nvarchar1=?,@nvarchar2=?,@nvarchar3=?,@nvarchar7=?,@nvarchar10=?,@nvarchar11=?,@nvarchar12=?,@nvarchar13=?,@nvarchar14=?,@tp_ContentType=?,@tp_ModerationStatus=?,@tp_ItemOrder = 12700.0000000000,@acl=0xF3FE000001000000000000000400000003000000FFFFFFFFFFFFFF7F0400000061104308B000000005000000EF12433CB001000007000000FFFFFFFFFFFFFF7F; IF @@iRet<> 0 GOTO done; done: IF @@iRet = 0 BEGIN EXEC proc_GetLinkInfoSingleDoc @@S,@DN,@LN, @@Level; END ELSE ROLLBACK; SET ?=@@Level; SET ?=@@iRet;" This part of the log references on of the files I was copying, a large one, 12 megs or so. The SharePoint Central Administration's recycle bin is empty, and I hadn't made a backup of the site collection yet. My questions are, first why did this happen exactly, and are all the sites actually gone. I think the answer to the latter is yes, but I was under the impression that Sharepoint used several layers of redundancy to prevent this from happening.

Hi, From the error message, I think the issue is from the transaction in the database for the size of the files copied is too large. Have you set your site collection quota? What did you mean of “the entire site collection was gone”? Can you see the site collection in the central administration? Or you just cannot find the page when you open the site URL? Please check your event log to see if there are some related errors with detail information. And check the corresponding content DB in your database server to see if it is working fine. Hope it is helpful!Seven