I am trying to restore a site collection backup from production on the dev site collection. Old dev site collection already exists, but I am trying to overwrite that with the latest copy.
I ran following command
Restore-SPSite "http://mydevsitecollectionpath/" -Path "D:pathname12102020.bak" -Force
I am getting following error
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. At line:1 char:1 + Restore-SPSite "http://dev-theloop.legalaid.ab.ca/" -Path "D:SCSLoopbackupsl ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidData: (Microsoft.Share...dletRestoreSite:SPCmdletRestoreSite) (Restore-SPSite), I nvalidOperationException + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletRestoreSite
I checked the lock status and its not locked, Database is not read-only its online and ready, Maximum number of site collections are set to 5000, Current number of site collections are 2.
After some research I have found some answers, which says to create a new content db and restore it on that. But I want to replace the existing one, if it is not possible I would like to know why.