SharePoint 2010: Error – Restore-SPSite : No content databases are available for this operation….

While restoring Sites using power shell, once can come across such a kind of error as given below:

“Restore-SPSite : No content databases are available for this operation but the site collection is scheduled for deletion in at least one content database.  Either wait for the deletion operation to complete or create a content database, and then try the operation again. To create a content database, click “Content databases” on the Application Management page, select the Web application to use, and then click “Add a content database”.


That actually means that a site is already  exist with this content database.
To resolve this issue.

  1. Use the command ‘Get-SPDeletedSite’ to see all the marked sites that are scheduled for deletion.
  2. Delete the site collection that you think is hosting the above backed up content databa using Remove-SPDeletedSite  command. From Get-SPDeletedSite you get the SiteID which will be used in Remove-SPDeletedSite. 
  3. Check with Get-SPDeletedSite once again if the site is deleted. 
  4. Then move to the Central Admin > Monitoring > Review Timerjobs > look for “Run Gradual Site Deletion” Timer Job for your required webapplication. 
  5. After running this TImer job, try restoring the Site collection again. 
References: 
http://sharepoint.stackexchange.com/questions/31048/restore-spsite-reports-no-content-databases-are-available-for-this-operation
https://social.technet.microsoft.com/Forums/office/en-US/3b22966a-ef4a-419b-a266-51efbddb04d3/restorespsite-reports-no-content-databases-are-available-for-this-operation-but-the-site?forum=sharepointadminprevious
Hope this helps. 
Cheers
Vaqar

Vaqar Hyder

E: vaqar.hyder3567@gmail.com

A:

Siebenb�rgen Stra�e 2/1, Korntal-M�nchingen, 70825, PK

Hire me on Freelancer.com

Post navigation

Leave a Reply

Your email address will not be published. Required fields are marked *