Introduction

In this article, we will go through restoring a larger volume of data. The script is written by Jose and is slightly modified by George (kudos to both George and Jose) and this script has control on no. of items that can be retrieved and no. of items to run the batch operation, to overcome the throttle limitation from Microsoft.

Steps

Step 1

Copy the code and save it with the proper file name in your local Powershell ISE. Here I have saved it as Restore-Recyclebin-LargerVolume.ps1. The code can be found below URL

https://github.com/TheGeorgeDougherty/O365-PS-Scripts/blob/master/SPOnline-Restore-RecycleBin

simply copy the entire code. I was trying cloning using git commands but was not successful.

Restoring Larger Volume from SharePoint Recyclebin

Step 2

Update the code to support MFA by adding the parameter interactive at line 27.

Restoring Larger Volume from SharePoint Recyclebin

Step 3

Save the file and import the file, in this case, Restore-Recyclebin-LargerVolume.ps1 into your Powershell command line.

Restoring Larger Volume from SharePoint Recyclebin

Step 4

Run the function with site collection and required parameters.

$SiteUrl="https://YOURCOMPANY.sharepoint.com/sites/SITENAME"
$BatchSize=100
$MaxRows=2000
$DelEmail = [email protected] #(email of the user)

Restore-RecycleBin-siteUrl$SiteUrl-maxRows$MaxRows-batchSize$BatchSize

Restoring Larger Volume from SharePoint Recyclebin

Replace the $SiteUrl with your company URL.

Step 5

Once the above steps are followed run the restore operation with the required parameters. You will be prompted to login. Make sure the account has Site Collection admin rights.

Once connected successfully, it will fetch the items from recycle bin with 100 items in batch and restores up to 2000 items since in this case the batch size is given as 100 and max items to restore are given as 2000.

Restoring Larger Volume from SharePoint Recyclebin

Restoring Larger Volume from SharePoint Recyclebin

Points to Note

Restoring Larger Volume from SharePoint Recyclebin

During the restore when trying to access the site, you might be getting the below error message,

This is due to the restore operation, the SharePoint sites try to not access/process new requests. Try accessing the site in the next 15 to 20 minutes.

Due to the above reasons, it is always recommended to try large restore operation outside the normal business hours.

Conclusion

Thus, in this article, we have seen how to retrieve a large volume of items from recycle bin using Powershell script by specifying the batch size and max items to retrieve. These settings are recommended to overcome the throttling enforced by SharePoint. You can refer to the attached PS script.

References