October 5, 2016

Error occurred while restoring site to new tenant - 0x80070003

While restoring site collection from one farm to another using power shell command: Restore-SPSite, I am getting below error.

Error: :-  <nativehr>0x80070003</nativehr><nativestack></nativestack>.Exception.GetType().FullName, <nativehr>0x80070003</nativehr><nativestack></nativestack>.Exception.Message

Below are few possible reasons you might get this error:

1) SharePoint Version differs: Version may be lower in destination farm than source farm environment. It can be verified by Go to Central Administration --> System Settings --> Manage Servers in the farm and check version.

https://1.bp.blogspot.com/-FlaoqNYuwLE/V-PO4baHDqI/AAAAAAAAAA0/xwX8Ky-Z6yUbU0x5pRdDv0MDKr7lGjNAwCLcB/s320/blog%2Bpics.png


Resolution: Version in destination farm i.e. where we restore site collection must be same as source. Upgrade the version by installing necessary Service packs or Cumulative Updates.

2) SQL Server Version differs: SQL Instance version may differ in destination farm where we are restoring site collection, from the source farm where we have taken site collection backup.

Resolution: Install correct version of SQL Server with service pack in destination farm.

https://1.bp.blogspot.com/-eIIx3-ENerY/V-PQwvoTXUI/AAAAAAAAAA8/MWGCwfxKMIwQsSKGaxYqrDKuRny02ek8QCLcB/s400/sql%2Bserv.png


3) Memory Insufficient: In my case, both SharePoint farm and SQL Server versions were same. So, I checked SQL Server Logs through ULS log viewer and came to know that there was insufficient memory to execute queries in content database.

Resolution: Connect SQL Server by SQL Server Management Studio --> Right click and go to properties and increase Maximum Server Memory according to need.

https://4.bp.blogspot.com/-NIevkb_TAoU/V-PTKJINEEI/AAAAAAAAABM/0J71V6PkhO8HZMk65-y6OhI56D5YBCQXgCLcB/s640/3.png\



https://1.bp.blogspot.com/-upouqCG_JcQ/V-PTKFhqD_I/AAAAAAAAABI/ZemcqDy6o-wbPHz3pvUq2skECKv2ijcwQCLcB/s640/4.png


 If you have any questions you can reach out our SharePoint Consulting team here.




No comments:

Post a Comment