Restore-SPSite: The operation that you are attempting to perform cannot be completed successfully.

Hi All,

In my day to work, I got a chance to restore site collection from backup. But I got the below Issue while restoring the Site Backup.

Restore-SPSite: The operation that you are attempting to perform cannot be completed successfully.  No content databases in the web application were available to store your site collection.  The existing content databases may have reached the maximum number of site collections, or be set to read-only, or be offline, or may already contain a copy of this site collection.  Create another content database for the Web application and then try the operation again.

Note: Before restoring the site collection ,I have created one site collection with same name the deleted it with some concerns.

Some of the web sites suggested that , In some cases if we are trying to restore a new site with the same url that was deleted some time ago, there are possibilities it has not been removed from the database permanently in that we have to try this.

Get-SPDeletedSite '/Site/cat*'

By using the above command we can get the Site ID’s.

Then, Remove the site by using the following site.

Remove-SPDeletedSite -Identity <<Site ID Name>>

I have deleted site by using the Powershell, but still facing the same issue.then I resolved the issue by using the below command.

Syntax:

Restore-SPSite <<Site URL>> -Path <<Backup Path.bak>> -force –DatabaseServer <<server name>> -DatabaseName <<Database Name>>

Example:

Restore-SPSite http://abcd:7902/sites/SharePointKitchen -Path D:\Backup\SPKitchen.bak -force –DatabaseServer SP2106 -DatabaseName WSS_Content_SPKitchen

References:
https://technet.microsoft.com/en-us/library/hh286316.aspx?f=255&MSPPError=-2147217396
https://technet.microsoft.com/en-us/library/hh286317.aspx?f=255&MSPPError=-2147217396

Thanks.

Related Post