Script to make unlock the sites from particualr db

Question

Particular db has sites, in this db site status are read only in sharepoint
I want to unlock all sites from that db. Please help me with script. Thank you.

Answer 1

Hi, @sns ,

You can use the following script to unlock sites from certain database.

$db=Get-SPContentDatabase | where-object {$_.Name -eq '<Content Database Name>'}  
$sites=Get-SPSite -ContentDatabase $db.id  
foreach($site in $sites)  
	{  
		Set-SPSite -Identity $site.URL -LockState Unlock  
	}  

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.