cancel
Showing results for 
Search instead for 
Did you mean: 

Got return code- 2804 when restore sub-site of SharePoint

harryyu
Level 4

We are using NetBackup 7.1.0.2 to backup Sharepoint 2010 SP1 (Client version is 7.1.0.3) with GRT.

Backup using GRT/non-GRT works without problem.

I try to delete a sub-site or a site and restore it using GRT images. I got error 2804.

Job logs show:

05/28/2012 13:45:59 - Error bpbrm (pid=15588) from client TOPPSQL03: ERR - error writing file: SharePoint - Connected\Content-DB 2 (TOPPSQL03/WSS_Connected_IS_Content)\WSS_Connected_IS_Content\/collaboration/IS\GRTTest2\GRTTEST2SUBSITE\Shared Documents\Movie.xls

 

ncfgre logs show:

0,51216,158,352,970,1338227174840,28424,29208,0:,155:<FROM BEDS>Error - Adding document: collaboration/IS/GRTTest2/GRTTEST2SU
BSITE/Shared Documents/Intranet_Deployment_Guide_v1.1.docx (../BEDSContext.cpp:124),21:[fsys\spsv2\spsv2brk],1
0,51216,158,352,971,1338227174840,28424,29208,0:,239:<FROM BEDS>SQLSTATE(23000) - Native Error(2627)!Message: [Microsoft][ODB
C SQL Server Driver][SQL Server]Violation of UNIQUE KEY constraint 'Docs_IdLevelUnique'. Cannot insert duplicate key in objec
t 'dbo.AllDocs'.! (../BEDSContext.cpp:124),21:[fsys\spsv2\spsv2brk],1
0,51216,158,352,972,1338227174840,28424,29208,0:,164:<FROM BEDS>SQLSTATE(01000) - Native Error(3621)!Message: [Microsoft][ODB
C SQL Server Driver][SQL Server]The statement has been terminated.! (../BEDSContext.cpp:124),21:[fsys\spsv2\spsv2brk],1
0,51216,158,352,1229,1338227176033,28424,29208,0:,208:<FROM BEDS>SQLSTATE(42000) - Native Error(8169)!Message: [Microsoft][OD
BC SQL Server Driver][SQL Server]Conversion failed when converting from a character string to uniqueidentifier.! (../BEDSCont
ext.cpp:124),21:[fsys\spsv2\spsv2brk],1
0,51216,158,352,1230,1338227176047,28424,29208,0:,208:<FROM BEDS>SQLSTATE(42000) - Native Error(8169)!Message: [Microsoft][OD
BC SQL Server Driver][SQL Server]Conversion failed when converting from a character string to uniqueidentifier.! (../BEDSCont
ext.cpp:124),21:[fsys\spsv2\spsv2brk],1
0,51216,311,352,18,1338227176072,28424,29208,0:,274:Sending to bpbrm: ERR - error writing file: SharePoint - Connected\Conten
t-DB 2 (TOPPSQL03/WSS_Connected_IS_Content)\WSS_Connected_IS_Content\/collaboration/IS\GRTTest2\GRTTEST2SUBSITE\Shared Docume
 (../BRMObserverDepreciated.cpp:475),29:BRMObserverDepreciated::write,1
0,51216,158,352,1376,1338227176109,28424,29208,0:,114:<FROM BEDS>FS_FreeOSPathOrNameQueueInHand: Error. QueueCount( &fsh->ava
il_name_q  ) > 8 ! (../BEDSContext.cpp:124),20:[fsys\shared]       ,1
1,51216,309,352,909,1338227176635,28424,29208,0:,0:,38:ConfigDataIterator::metadataIdCallback,1,(35|A21:3:Error_Messages_Max;|A2:10|) 
 
 
It looks like the real file in SQL DB was not deleted when I delete the site or sub-site.
 
I had followed below URL:
 
The default.aspx can be restored, but still got same error when restore the rest of stuff.
 
 
2 REPLIES 2

harryyu
Level 4

I tried to restore a site in our DEV environment with SQL 2005. It works fine.

SQL 2008 has problem when delete a site. It didn't remove all objects from database I think.

V4
Level 6
Partner Accredited

Violation of UNIQUE KEY constraint 'Docs_IdLevelUnique'. Cannot insert duplicate key in object

 

worth checking