IT Desk (UK) Limited
asked on
Sharepoint Restore Problems
Hi Guys,
I'm trying to move Sharepoint 2010 to a new 2013 deployment but it is also on a new domain.
I have ran a backup from the 2010 deployment and this went through no problem. I have tried to restore but I get constant SQL problems on restore. I'm guessing this is a permissions problem - but I don't know how to overcome this. I have attached the Log file to this post also. Any help would be much appreciated.
BridgeSharepointRestoreLog.txt
I'm trying to move Sharepoint 2010 to a new 2013 deployment but it is also on a new domain.
I have ran a backup from the 2010 deployment and this went through no problem. I have tried to restore but I get constant SQL problems on restore. I'm guessing this is a permissions problem - but I don't know how to overcome this. I have attached the Log file to this post also. Any help would be much appreciated.
BridgeSharepointRestoreLog.txt
ASKER
You mention you try to restore... what do you mean exactly and how does that relate to SharePoint 2013. Are you restoring your 2010 db in to a 2013 farm?
Yes - so I have run a backup from 2010 farm, moved that backup over to new server/domain set data permissions then then tried to restore into sharepoint 2013.
The error is what I get above.
Here is some information that may be helpful to you:
https://technet.microsoft.com/en-us/library/cc263299.aspx
http://www.falconitservices.com/support/KB/Lists/Posts/Post.aspx?ID=124
Hope that helps...
https://technet.microsoft.com/en-us/library/cc263299.aspx
http://www.falconitservices.com/support/KB/Lists/Posts/Post.aspx?ID=124
Hope that helps...
ASKER
Ok, based on this information - would you suggest upgrading the old server then moving over to the new one?
The internal SQL exception reads:
From what I believe, the restore sequence is trying to add new logins and users to the db_owner role.
Just to cross-check: Are you restoring the database with a login having sysadmin privileges on the SQL Server?
SqlException: Cannot alter the role 'db_owner', because it does not exist or you do not have permission.
Cannot alter the role 'db_owner', because it does not exist or you do not have permission.
From what I believe, the restore sequence is trying to add new logins and users to the db_owner role.
Just to cross-check: Are you restoring the database with a login having sysadmin privileges on the SQL Server?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Some more information would be helpful.. thanks