0

I tried to rename the site collection host header (see post here) and it did not work, so I found this blog and thought I could give Backup-SPSite, Remove-SPSite and Restore-SPSite a try. I used this code below, of course changed the values.

Backup-SPSite http://server_name/sites/site_name -Path C:\Backup\site_name.bak 
Remove-SPSite –Identity http://server_name/sites/site_name –Confirm:$False 
Restore-SPSite http://www.example.com -Path C:\Backup\site_name.bak -HostHeaderWebApplication http://server_name

When I tried to restore it back, it said that it could not open database

Restore-SPSite : Cannot open database "SP_Content_1" requested by the login. The login failed. Login failed for user 'domain\svc_farm'. At line:1 char:1 + Restore-SPSite https://newsite -Path D:\backupsite.bak -HostHeader ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidData: (Microsoft.Share...dletRestoreSite:SPCmdletRestoreSite) [Restore-SPSite], SqlException + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletRestoreSite

The database SP_Content_1 does not exist actually. How is it trying to log in when it does not exist? Therefore, I created a database, gave the user access to the database and tried it again.

Restore-SPSite http://www.example.com -Path C:\Backup\site_name.bak -HostHeaderWebApplication http://server_name

This time I am getting the following error.

Restore-SPSite : Invalid object name 'Sites'. At line:1 char:1 + Restore-SPSite https://sitename.com -Path D:\backupsite.bak -HostHeader ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidData: (Microsoft.Share...dletRestoreSite:SPCmdletRestoreSite) [Restore-SPSite], SqlException + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletRestoreSite

The environment is the same one. I have used the Get-SPDeletedSite and there are no deleted sites as I cleared them all.

Any idea how should I proceed from here?

Improve this question

1 Answer 1

Reset to default
1

try to use something like this:

Restore-SPSite -Identity http://newurl -DatabaseServer "SQLS01\instance" -Path D:\backup.bak -DatabaseName "SP_Content" -HostHeaderWebApplication https://webapphostheaderurl

I have included the databaseserver and databasename in the script. Let us know what you get.

Improve this answer
3
  • it worked!! but I am getting this warning: WARNING: The port specified for the new host header site does not match any known bindings in the specified Web Application. The new site will not be acce ssible if the Web Application is not extended to an IIS Web Site serving this port.
    – Burre Ifort
    Commented Dec 20, 2017 at 14:56
  • Is ur hostname site collection using different port than the web application itself?
    – Waqas Sarwar MVP ♦
    Commented Dec 20, 2017 at 15:06
  • no it is using the same port. 443
    – Burre Ifort
    Commented Dec 20, 2017 at 16:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.