I am trying to migrate a site collection using the STSADM backup/restore utility and am having some issues restoring it to a particular server. The error I get should be self explanatory but I cannot for the life of me figure out what I have configured wrong. The error I receive is :"The site collection could not be restored. If this problem persists, please make sure the content databases are available and have sufficient free space."The size of the backup is 800mb and there is 37gb of free space on the C:/ drive for the server and 400gb of free space on the data partition. I was able to succesfully restore the site collection in a test enviorment but I cannot seem to get the same results in production. The exact comand I am using is as follows:stsadm -o restore -url http://intranet.company.com/dept/IT -filename C:\backup.datAny help or suggestions would be greatly appreciated!

Hello,Did you checked available space on your SQL server?Make sure that you have available room in the content DB. That should get you going.RegardsIvan Bondy - MCPD, MCDBA, MCSA, MCTS - Sharepoint consultant

We have 10gb of free space on the content DB, I would think thats enough to perform a restore. Do you think we should expand it further?

Just create a new site collection & check if you are able to restore it in that new collection. Thanks, Arpit

Have you got SQL Server or the Desktop version? If I'm not wrong, Desktop has a storage limit of 4Gb, perhaps you're over it.

We have SQL Server 2005 and the content DB is far from full. Is there perhaps another configuration database that is causing this error? Currently WSS_Content has 10gb free space. I am not sure where else to go with this.

I would check a couple of items. Are you running stsadm as an account that has sufficient permissions? Farm admin account? Are you restoring to a url that already has an existing site collection? This can happen if you are restoring back to an existing url, or if you are trying to restore the same site collection over itself and did not delete the original.you mention that there is plenty of free space, have you checked the drives of the SharePoint server you are doing the STSADM command from as well as the drives on the SQL server? One other item to check is well, if you are restoring toa seperate farm you want to be sure that the farms are at the same patching level and any customizations within the site collection your are restoring exist in the farm as well.

- I am fairly sure the account has sufficient permissions, it is under Farm Administrators.- The restore wont work for any url, I have tried new URLs and old ones with no luck.- There is 40gb of free space on the drive of the Sharepoint Server, I think this should be more than enough.How do I check the patching level? And would that throw an error about resizing the DB?

To check the patching level you can check add/remove programs to see what updates have been applied. Another quick check is go to site settings on any web site and look at the version number that shows up on that screen.

The version are the same. I feel like I am missing something critical here that is causing this to fail.

Are the permissions on the DB setup correctly? Can you log in as the service account and see if it works?

Checking the logs I was able to get a little more information:stsadm: The site collection could not be restored. If this problem persists, please make sure the content databases are available and have sufficient free space. Callstack:at Microsoft.SharePoint.Library.SPRequest.RestoreSite(String bstrUrl, String bstrFilename, Boolean bCurrentServerADMode)at Microsoft.SharePoint.SPSite.Restore(String filename, Boolean isADMode)at Microsoft.SharePoint.Administration.SPSiteCollection.Restore(String strSiteUrl, String strFilename, Boolean bOverwrite, Boolean hostHeaderAsSiteName)at Microsoft.SharePoint.StsAdmin.SPAdminRestore.RunSiteCollectionRestore(StringDictionary keyValues)at Microsoft.SharePoint.StsAdmin.SPAdminRestore.Run(StringDictionary keyValues)at Microsoft.SharePoint.StsAdmin.SPStsAdmin.RunOperation(SPGlobalAdmin globalAdmin, String strOperation, StringDictionary keyValues, SPParamCollection pars)

Further logging informationStarting restore of site collection: 'http://intranet.site.com/dept/Internal', requested by: Domain-User\mtschiegg, source: C:\backup2.bak Unexpected query execution failure, error code 3621. Additional error information from SQL Server is included below. "The statement has been terminated." Query text (if available):"SETNOCOUNTON;insertintoAllDocs(Id,SiteId,DirName,LeafName,WebId,ListId,DoclibRowId,Type,Size,MetaInfoSize,Version,UIVersion,Dirty,ListDataDirty,CacheParseId,DocFlags,ThicketFlag,CharSet,ProgId,TimeCreated,TimeLastModified,NextToLastTimeModified,MetaInfoTimeLastModified,TimeLastWritten,DeleteTransactionId,SetupPathVersion,SetupPath,SetupPathUser,CheckoutUserId,CheckoutDate,CheckoutExpires,VersionCreatedSinceSTCheckout,VirusVendorID,VirusStatus,VirusInfo,MetaInfo,UnVersionedMetaInfo,UnVersionedMetaInfoSize,UnVersionedMetaInfoVersion,WelcomePageUrl,WelcomePageParameters,IsCurrentVersion,Level,CheckinComment,Au...ditFlags,InheritAuditFlags,DraftOwnerId,ParentId,ScopeId,BuildDependencySet,ParentVersion,TransformerId,ParentLeafName,CtoOffset,ItemChildCount,FolderChildCount)values('24C39CBD-6E9A-40D1-ABD9-8CF7ED41E47D','23209965-EBBB-4F14-B284-E86F5297D9C6',N'sites',N'VR-ITTeam','9FC4DF72-ADB7-4E7C-9B40-54867E804109',NULL,NULL,2,NULL,NULL,NULL,512,NULL,0,NULL,NULL,0,NULL,NULL,0x0000992b00f6b634,0x00009a9c014e15c8,0x0000999b010adba0,0x0000998300d55868,NULL,0x,3,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,'00000000-0000-0000-0000-000000000000','40A03968-B4E3-4DA9-ADB8-5290DF09990B',NULL,NULL,NULL,NULL,NULL,0,0);IF@@ROWCOUNT=0OR@@ERROR<>0RETURN;insertintoAllDocs(Id,SiteId,DirName,LeafName,WebId,ListId,DoclibRowId,Type,Size,MetaInfoSize,Version,UIVersion,Dirty,ListDataDirty,CacheParseId,DocFlags,ThicketFlag,CharSet,ProgId,TimeCreated,TimeLastModified,NextToLastTimeModified,MetaInfoTimeLastModified,TimeLastWritten,DeleteTransactionId,SetupPathVersion,SetupPath,SetupPathUser,CheckoutUserId,CheckoutDate,CheckoutExpires,VersionCreatedSinceSTCheckout,VirusVendorID,VirusStatus,VirusInfo,MetaInfo,UnVersionedMetaInfo,UnVersionedMetaInfoSize,UnVersionedMetaInfoVersion,WelcomePageUrl,WelcomePageParameters,IsCurrentVersion,Level,CheckinComment,AuditFlags,InheritAuditFlags,DraftOwnerId,ParentId,ScopeId,BuildDependencySet,ParentVersion,TransformerId,ParentLeafName,CtoOffset,ItemChildCount,FolderChildCount)values('69AA17A7-201D-4E13-A8AD-296BDAA9519B','23209965-EBBB-4F14-B284-E86F5297D9C6',N'sites/VR-ITTeam',N'_catalogs','9FC4DF72-ADB7-4E7C-9B40-54867E804109',NULL,NULL,1,NULL,NULL,NULL,512,NULL,0,NULL,0,0,NULL,NULL,0x0000992b00f6bd3c,0x0000992b00f6bd3c,NULL,NULL,NULL,0x,3,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,'24C39CBD-6E9A-40D1-ABD9-8CF7ED41E47D','40A03968-B4E3-4DA9-ADB8-5290DF09990B',NULL,NULL,NULL,NULL,NULL,0,0);IF@@ROWCOUNT=0OR@@ERROR<>0RETURN;insertintoAllDocs(Id,SiteId,DirName,LeafName,WebId,ListId,DoclibRowId,Type,Size,MetaInfoSize,Version,UIVersion,Dirty,ListDataDirty,CacheParseId,DocFlags,ThicketFlag,CharSet,ProgId,TimeCreated,TimeLastModified,NextToLastTimeModified,MetaInfoTimeLastModified,TimeLastWritten,DeleteTransactionId,SetupPathVersion,SetupPath,SetupPathUser,CheckoutUserId,CheckoutDate,CheckoutExpires,VersionCreatedSinceSTCheckout,VirusVendorID,VirusStatus,VirusInfo,MetaInfo,UnVersionedMetaInfo,UnVersionedMetaInfoSize,UnVersionedMetaInfoVersion,WelcomePageUrl,WelcomePageParameters,IsCurrentVersion,Level,CheckinComment,AuditFlags,InheritAuditFlags,DraftOwnerId,ParentId,ScopeId,BuildDependencySet,ParentVersion,TransformerId,ParentLeafName,CtoOffset,ItemChildCount,FolderChildCount)values('9F9910A7-8DC6-4451-A9FE-65C9F65B1489','23209965-EBBB-4F14-B284-E86F5297D9C6',N'sites/VR-ITTeam',N'_cts','9FC4DF72-ADB7-4E7C-9B40-54867E804109',NULL,NULL,1,NULL,NULL,NULL,512,NULL,0,NULL,0,0,NULL,NULL,0x0000992b00f6bae4,0x0000994e01024d64,0x0000992b00f6bae4,NULL,NULL,0x,3,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,'24C39CBD-6E9A-40D1-ABD9-8CF7ED41E47D','40A03968-B4E3-4DA9-ADB8-5290DF09990B',NULL,NULL,NULL,NULL,NULL,0,0);IF@@ROWCOUNT=0OR@@ERROR<>0RETURN;insertintoAllDocs(Id,SiteId,DirName,LeafName,WebId,ListId,DoclibRowId,Type,Size,MetaInfoSize,Version,UIVersion,Dirty,ListDataDirty,CacheParseId,DocFlags,ThicketFlag,CharSet,ProgId,TimeCreated,TimeLastModified,NextToLastTimeModified,MetaInfoTimeLastModified,TimeLastWritten,DeleteTransactionId,SetupPathVersion,SetupPath,SetupPathUser,CheckoutUserId,CheckoutDate,CheckoutExpires,VersionCreatedSinceSTCheckout,VirusVendorID,VirusStatus,VirusInfo,MetaInfo,UnVersionedMetaInfo,UnVersionedMetaInfoSize,UnVersionedMetaInfoVersion,WelcomePageUrl,WelcomePageParameters,IsCurrentVersion,Level,CheckinComment,AuditFlags,InheritAuditFlags,DraftOwnerId,ParentId,ScopeId,BuildDependencySet,ParentVersion,TransformerId,ParentLeafName,CtoOffset,ItemChildCount,FolderChildCount)values('5470A8F0-4490-48DE-8AB5-5C164521DA97','23209965-EBBB-4F14-B284-E86F5297D9C6',N'sites/VR-ITTeam',N'_private','9FC4DF72-ADB7-4E7C-9B40-54867E804109',NULL,NULL,1,NULL,NULL,NULL,512,NULL,0,NULL,0,0,NULL,NULL,0x0000992b00f6b634,0x0000992b00f6b634,NULL,NULL,NULL,0x,3,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,'24C39CBD-6E9A-40D1-ABD9-8CF7ED41E47D','40A03968-B4E3-4DA9-ADB8-5290DF09990B',NULL,NULL,NULL,NULL,NULL,0,0);IF@@ROWCOUNT=0OR@@ERROR<>0RETURN;insertintoAllDocs(Id,SiteId,DirName,LeafName,WebId,ListId,DoclibRowId,Type,Size,MetaInfoSize,Version,UIVersion,Dirty,ListDataDirty,CacheParseId,DocFlags,ThicketFlag,CharSet,ProgId,TimeCreated,TimeLastModified,NextToLastTimeModified,MetaInfoTimeLastModified,TimeLastWritten,DeleteTransactionId,SetupPathVersion,SetupPath,SetupPathUser,CheckoutUserId,CheckoutDate,CheckoutExpires,VersionCreatedSinceSTCheckout,VirusVendorID,VirusStatus,VirusInfo,MetaInfo,UnVersionedMetaInfo,UnVersionedMetaInfoSize,UnVersionedMetaInfoVersion,WelcomePageUrl,WelcomePageParameters,IsCurrentVersion,Level,CheckinComment,AuditFlags,InheritAuditFlags,DraftOwnerId,ParentId,ScopeId,BuildDependencySet,ParentVersion,TransformerId,ParentLeafName,CtoOffset,ItemChildCount,FolderChildCount)values('022F97A5-CEC8-4B50-BF0B-2F10F1CDCFF3','23209965-EBBB-4F14-B284-E86F5297D9C6',N'sites/VR-ITTeam',N'_themes','9FC4DF72-ADB7-4E7C-9B40-54867E804109',NULL,NULL,1,NULL,NULL,NULL,512,NULL,0,NULL,0,0,NULL,NULL,0x0000992b00f741a8,0x0000992e00e607e4,0x0000992b00f8889c,NULL,NULL,0x,3,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,'24C39CBD-6E9A-40D1-ABD9-8CF7ED41E47D','40A03968-B4E3-4DA9-ADB8-5290DF09990B',NULL,NULL,NULL,NULL,NULL,0,0);IF@@ROWCOUNT=0OR@@ERROR<>0RETURN;insertintoAllDocs(Id,SiteId,DirName,LeafName,WebId,ListId,DoclibRowId,Type,Size,MetaInfoSize,Version,UIVersion,Dirty,ListDataDirty,CacheParseId,DocFlags,ThicketFlag,CharSet,ProgId,TimeCreated,TimeLastModified,NextToLastTimeModified,MetaInfoTimeLastModified,TimeLastWritten,DeleteTransactionId,SetupPathVersion,SetupPath,SetupPathUser,CheckoutUserId,CheckoutDate,CheckoutExpires,VersionCreatedSinceSTCheckout,VirusVendorID,VirusStatus,VirusInfo,MetaInfo,UnVersionedMetaInfo,UnVersionedMetaInfoSize,UnVersionedMetaInfoVersion,WelcomePageUrl,WelcomePageParameters,IsCurrentVersion,Level,CheckinComment,AuditFlags,InheritAuditFlags,DraftOwnerId,ParentId,ScopeId,BuildDependencySet,ParentVersion,TransformerId,ParentLeafName,CtoOffset,ItemChildCount,FolderChildCount)values('B3E1C926-D270-4174-A6C9-8C45690A1408','23209965-EBBB-4F14-B284-E86F5297D9C6',N'sites/VR-ITTeam',N'_vti_pvt','9FC4DF72-ADB7-4E7C-9B40-54867E804109',NULL,NULL,1,NULL,NULL,NULL,512,NULL,0,NULL,0,0,NULL,NULL,0x0000992b00f6b634,0x0000992b00f6b634,NULL,NULL,NULL,0x,3,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,'24C39CBD-6E9A-40D1-ABD9-8CF7ED41E47D','40A03968-B4E3-4DA9-ADB8-5290DF09990B',NULL,NULL,NULL,NULL,NULL,0,0);IF@@ROWCOUNT=0OR@@ERROR<>0RETURN;insertintoAllDocs(Id,SiteId,DirName,LeafName,WebId,ListId,DoclibRowId,Type,Size,MetaInfoSize,Version,UIVersion,Dirty,ListDataDirty,CacheParseId,DocFlags,ThicketFlag,CharSet,ProgId,TimeCreated,TimeLastModified,NextToLastTimeModified,MetaInfoTimeLastModified,TimeLastWritten,DeleteTransactionId,SetupPathVersion,SetupPath,SetupPathUser,CheckoutUserId,CheckoutDate,CheckoutExpires,VersionCreatedSinceSTCheckout,VirusVendorID,VirusStatus,VirusInfo,MetaInfo,UnVersionedMetaInfo,UnVersionedMetaInfoSize,UnVersionedMetaInfoVersion,WelcomePageUrl,WelcomePageParameters,IsCurrentVersion,Level,CheckinComment,AuditFlags,InheritAuditFlags,DraftOwnerId,ParentId,ScopeId,BuildDependencySet,ParentVersion,TransformerId,ParentLeafName,CtoOffset,ItemChildCount,FolderChildCount)values('5FCCE5B1-C4AB-4E24-BD7A-58A7B7FCBE68','23209965-EBBB-4F14-B284-E86F5297D9C6',N'sites/VR-ITTeam',N'ApplicationProgramMaintenance','9FC4DF72-ADB7-4E7C-9B40-54867E804109','1B90F707-A932-453D-8DFA-40AE21B1DD7D',NULL,1,NULL,NULL,NULL,512,NULL,0,NULL,NULL,0,NULL,NULL,0x0000997f0154ccec,0x0000998200d5a23c,0x0000998200d5a23c,NULL,NULL,0x,3,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,'24C39CBD-6E9A-40D1-ABD9-8CF7ED41E47D','40A03968-B4E3-4DA9-ADB8-5290DF09990B',NULL,NULL,NULL,NULL,NULL,0,0);IF@@ROWCOUNT=0OR@@ERROR<>0RETURN;insertintoAllDocs(Id,SiteId,DirName,LeafName,WebId,ListId,DoclibRowId,Type,Size,MetaInfoSize,Version,UIVersion,Dirty,ListDataDirty,CacheParseId,DocFlags,ThicketFlag,CharSet,ProgId,TimeCreated,TimeLastModified,NextToLastTimeModified,MetaInfoTimeLastModified,TimeLastWritten,DeleteTransactionId,SetupPathVersion,SetupPath,SetupPathUser,CheckoutUserId,CheckoutDate,CheckoutExpires,VersionCreatedSinceSTCheckout,VirusVendorID,VirusStatus,VirusInfo,MetaInfo,UnVersionedMetaInfo,UnVersionedMetaInfoSize,UnVersionedMetaInfoVersion,WelcomePageUrl,WelcomePageParameters,IsCurrentVersion,Level,CheckinComment,AuditFlags,InheritAuditFlags,DraftOwnerId,ParentId,ScopeId,BuildDependencySet,ParentVersion,TransformerId,ParentLeafName,CtoOffset,ItemChildCount,FolderChildCount)values('0A56B781-7EC6-43F7-99A1-F29451A5EA59','23209965-EBBB-4F14-B284-E86F5297D9C6',N'sites/VR-ITTeam',N'BackupandDisasterRecovery','9FC4DF72-ADB7-4E7C-9B40-54867E804109','6A9EF114-902E-43F4-9095-5FF841059243',NULL,1,NULL,NULL,NULL,512,NULL,0,NULL,NULL,0,NULL,NULL,0x0000997f013c4604,0x00009a9b00c219d8,0x00009a9b00c1ae08,NULL,NULL,0x,3,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,'24C39CBD-6E9A-40D1-ABD9-8CF7ED41E47D','40A03968-B4E3-4DA9-ADB8-5290DF09990B',NULL,NULL,NULL,NULL,NULL,15,0);IF@@ROWCOUNT=0OR@@ERROR<>0RETURN;insertintoAllDocs(Id,SiteId,DirName,LeafName,WebId,ListId,DoclibRowId,Type,Size,MetaInfoSize,Version,UIVersion,Dirty,ListDataDirty,CacheParseId,DocFlags,ThicketFlag,CharSet,ProgId,TimeCreated,TimeLastModified,NextToLastTimeModified,MetaInfoTimeLastModified,TimeLastWritten,DeleteTransactionId,SetupPathVersion,SetupPath,SetupPathUser,CheckoutUserId,CheckoutDate,CheckoutExpires,VersionCreatedSinceSTCheckout,VirusVendorID,VirusStatus,VirusInfo,MetaInfo,UnVersionedMetaInfo,UnVersionedMetaInfoSize,UnVersionedMetaInfoVersion,WelcomePageUrl,WelcomePageParameters,IsCurrentVersion,Level,CheckinComment,AuditFlags,InheritAuditFlags,DraftOwnerId,ParentId,ScopeId,BuildDependencySet,ParentVersion,TransformerId,ParentLeafName,CtoOffset,ItemChildCount,FolderChildCount)values('9F290AAE-72F7-4B29-B494-95AC9F7DA55B','23209965-EBBB-4F14-B284-E86F5297D9C6',N'sites/VR-ITTeam',N'BergerFishing','9FC4DF72-ADB7-4E7C-9B40-54867E804109','69BF21F8-751B-4BDB-99D3-3B12F59B53A8',NULL,1,NULL,NULL,NULL,512,NULL,0,NULL,NULL,0,NULL,NULL,0x0000999201265664,0x0000999201268094,NULL,NULL,NULL,0x,3,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,'24C39CBD-6E9A-40D1-ABD9-8CF7ED41E47D','40A03968-B4E3-4DA9-ADB8-5290DF09990B',NULL,NULL,NULL,NULL,NULL,1,0);IF@@ROWCOUNT=0OR@@ERROR<>0RETURN;insertintoAllDocs(Id,SiteId,DirName,LeafName,WebId,ListId,DoclibRowId,Type,Size,MetaInfoSize,Version,UIVersion,Dirty,ListDataDirty,CacheParseId,DocFlags,ThicketFlag,CharSet,ProgId,TimeCreated,TimeLastModified,NextToLastTimeModified,MetaInfoTimeLastModified,TimeLastWritten,DeleteTransactionId,SetupPathVersion,SetupPath,SetupPathUser,CheckoutUserId,CheckoutDate,CheckoutExpires,VersionCreatedSinceSTCheckout,VirusVendorID,VirusStatus,VirusInfo,MetaInfo,UnVersionedMetaInfo,UnVersionedMetaInfoSize,UnVersionedMetaInfoVersion,WelcomePageUrl,WelcomePageParameters,IsCurrentVersion,Level,CheckinComment,AuditFlags,InheritAuditFlags,DraftOwnerId,ParentId,ScopeId,BuildDependencySet,ParentVersion,TransformerId,ParentLeafName,CtoOffset,ItemChildCount,FolderChildCount)values('D9FDC48B-A52D-43A3-B0F7-FA67E9890AAF','23209965-EBBB-4F14-B284-E86F5297D9C6',N'sites/VR-ITTeam',N'CyberQueryRelatedDocumentation','9FC4DF72-ADB7-4E7C-9B40-54867E804109','0FA59D10-4381-4FE8-A425-DA4CBF59526A',NULL,1,NULL,NULL,NULL,512,NULL,0,NULL,NULL,0,NULL,NULL,0x0000998200bb26f0,0x0000998200ea7194,NULL,NULL,NULL,0x,3,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,'24C39CBD-6E9A-40D1-ABD9-8CF7ED41E47D','40A03968-B4E3-4DA9-ADB8-5290DF09990B',NULL,NULL,NULL,NULL,NULL,2,0);IF@@ROWCOUNT=0OR@@ERROR<>0RETURN;insertintoAllDocs(Id,SiteId,DirName,LeafName,WebId,ListId,DoclibRowId,Type,Size,MetaInfoSize,Version,UIVersion,Dirty,ListDataDirty,CacheParseId,DocFlags,ThicketFlag,CharSet,ProgId,TimeCreated,TimeLastModified,NextToLastTimeModified,MetaInfoTimeLastModified,TimeLastWritten,DeleteTransactionId,SetupPathVersion,SetupPath,SetupPathUser,CheckoutUserId,CheckoutDate,CheckoutExpires,VersionCreatedSinceSTCheckout,VirusVendorID,VirusStatus,VirusInfo,MetaInfo,UnVersionedMetaInfo,UnVersionedMetaInfoSize,UnVersionedMetaInfoVersion,WelcomePageUrl,WelcomePageParameters,IsCurrentVersion,Level,CheckinComment,AuditFlags,InheritAuditFlags,DraftOwnerId,ParentId,ScopeId,BuildDependencySet,ParentVersion,TransformerId,ParentLeafName,CtoOffset,ItemChildCount,FolderChildCount)values('A0F31F78-93CF-4033-AFC9-E7FEAEF63DAD','23209965-EBBB-4F14-B284-E86F5297D9C6',N'sites/VR-ITTeam',N'DatabaseManagement','9FC4DF72-ADB7-4E7C-9B40-54867E804109','B5294F46-09FC-42E2-B375-525B4DD20BB6',NULL,1,NULL,NULL,NULL,512,NULL,0,NULL,NULL,0,NULL,NULL,0x0000997f015701c4,0x0000998200cdf758,0x0000998200cdf758,NULL,NULL,0x,3,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,'24C39CBD-6E9A-40D1-ABD9-8CF7ED41E47D','40A03968-B4E3-4DA9-ADB8-5290DF09990B',NULL,NULL,NULL,NULL,NULL,0,0);IF@@ROWCOUNT=0OR@@ERROR<>0RETURN;insertintoAllDocs(Id,SiteId,DirName,LeafName,WebId,ListId,DoclibRowId,Type,Size,MetaInfoSize,Version,UIVersion,Dirty,ListDataDirty,CacheParseId,DocFlags,ThicketFlag,CharSet,ProgId,TimeCreated,TimeLastModified,NextToLastTimeModified,MetaInfoTimeLastModified,TimeLastWritten,DeleteTransactionId,SetupPathVersion,SetupPath,SetupPathUser,CheckoutUserId,CheckoutDate,CheckoutExpires,VersionCreatedSinceSTCheckout,VirusVendorID,VirusStatus,VirusInfo,MetaInfo,UnVersionedMetaInfo,UnVersionedMetaInfoSize,UnVersionedMetaInfoVersion,WelcomePageUrl,WelcomePageParameters,IsCurrentVersion,Level,CheckinComment,AuditFlags,InheritAuditFlags,DraftOwnerId,ParentId,ScopeId,BuildDependencySet,ParentVersion,TransformerId,ParentLeafName,CtoOffset,ItemChildCount,FolderChildCount)values('1099E004-541B-4FA4-B76D-FE59B5FDFA3A','23209965-EBBB-4F14-B284-E86F5297D9C6',N'sites/VR-ITTeam',N'Datacraft','9FC4DF72-ADB7-4E7C-9B40-54867E804109','A3ADBC14-3149-4ACA-9EDB-5590E0ED7863',NULL,1,NULL,NULL,NULL,512,NULL,0,NULL,NULL,0,NULL,NULL,0x00009ae000fbeaa0,0x00009ae000fd2960,NULL,NULL,NULL,0x,3,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,'24C39CBD-6E9A-40D1-ABD9-8CF7ED41E47D','40A03968-B4E3-4DA9-ADB8-5290DF09990B',NULL,NULL,NULL,NULL,NULL,3,0);IF@@ROWCOUNT=0OR@@ERROR<>0RETURN;insertintoAllDocs(Id,SiteId,DirName,LeafName,WebId,ListId,DoclibRowId,Type,Size,MetaInfoSize,Version,UIVersion,Dirty,ListDataDirty,CacheParseId,DocFlags,ThicketFlag,CharSet,ProgId,TimeCreated,TimeLastModified,NextToLastTimeModified,MetaInfoTimeLastModified,TimeLastWritten,DeleteTransactionId,SetupPathVersion,SetupPath,SetupPathUser,CheckoutUserId,CheckoutDate,CheckoutExpires,VersionCreatedSinceSTCheckout,VirusVendorID,VirusStatus,VirusInfo,MetaInfo,UnVersionedMetaInfo,UnVersionedMetaInfoSize,UnVersionedMetaInfoVersion,WelcomePageUrl,WelcomePageParameters,IsCurrentVersion,Level,CheckinComment,AuditFlags,InheritAuditFlags,DraftOwnerId,ParentId,ScopeId,BuildDependencySet,ParentVersion,TransformerId,ParentLeafName,CtoOffset,ItemChildCount,FolderChildCount)values('06BE6C66-FF89-4253-8678-03830D4DA986','23209965-EBBB-4F14-B284-E86F5297D9C6',N'sites/VR-ITTeam',N'default.aspx','9FC4DF72-ADB7-4E7C-9B40-54867E804109',NULL,NULL,0,3645,NULL,1,512,0,0,NULL,268,0,NULL,NULL,0x0000992b00f6ca20,0x0000992b00f6ca20,NULL,0x00009a9d01326c24,0x0000992b00f6ca20,0x,3,N'SiteTemplates\STS\default.aspx',N'GVRSIMSHAREP01\administrator',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,'24C39CBD-6E9A-40D1-ABD9-8CF7ED41E47D','40A03968-B4E3-4DA9-ADB8-5290DF09990B',0x01000101342F73697465732F56522D49545465616D2F5F636174616C6F67732F6D6173746572706167652F64656661756C742E6D61737465720100292F5F636F6E74726F6C74656D706C617465732F44657369676E4D6F6465436F6E736F6C652E6173637801001F2F5F636F6E74726F6C74656D706C617465732F57656C636F6D652E6173637800,NULL,NULL,NULL,NULL,0,0);IF@@ROWCOUNT=0OR@@ERROR<>0RETURN;SELECT0;"

And does the user account specified in the log have sufficient permissions on the DB? Testing with the service account should tell you.

Hi,1. Please check whether content db is attached with the source and destination sites.2. If u r trying to migrate to different server then make sure that both the servers are of same configuration.3. Try Export/import thru stsadm utility. You ll get it, I hope.ThanksMehmood

The user account has enough permissions. Just as a test case I tried restoring a small site collection, only 80mb, and it worked just fine. That tells me:- Its not a permissions things- The database is set up properly and working- It must be some kind of size restriction somewhere....I am going to toy around with that import/export utility, but I dont think that it migrates everything that I need.

I hade the EXACT same issue, same error in the logs. It turns out the .dat file hade been corrupted when I copied it across the network. I copied it again and it restored fine.

Had similar problem in Sharepoint 2010. Using Powershell Restore-SPSite command to restore a site collection from one farm to another. Sequence of events ... 1. Restored site collection via Restore-SPSite successfully (about 500MB). 2. Used Central Admin to delete the site collection. 3. Tried to restore it again and got the error ... Restore-SPSite : The site collection could not be restored. If this problem persists, please make sure the content databases are available and have sufficient free space. At line:1 char:15 + CategoryInfo : InvalidData:(Microsoft.Share...dletRestoreSite: SPCmdletRestoreSite) [Restore-SPSite], SPException + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletRestoreSite Turns out deleting the site collection in Central Admin doesn't delete it right away and it's waiting for the Gradual Delete Timer job to run (daily). Solution was to manually run the Gradual Delete Timer job. Then run the Restore-SPSite again.

I solved this problem by re-creating the web application. Jeff ANGAMA. Sharepoint Consultant Blog : http://jeff-sharepoint-note.blogspot.com/

Hi, There may be a possibility that your content DB having an orphan entry. Please check my blog post about the orphan entries and the solution to over come this issue. Check http://chanakyajayabalan.wordpress.com/2010/03/22/the-site-collection-could-not-be-restored-please-make-sure-the-content-databases-are-available-and-have-sufficient-free-space-sharepoint-orphaned-sites/ Thanks, Chanakya

Hi, Please visit this link for the solution - http://www.manvir.net/restore-spsite-the-site-collection-could-not-be-restored-if-this-problem-persists-please-make-sure-the-content-databases-are-available-and-have-sufficient-free-space-5/ Thanks Manvir

Hi, Its a weird error as root cause is something else than what the error message says. Here is the solution - http://manvir.net/ Thanks, Manvir Manvir