Sharepoint Restore Problems

itd-helpdesk
itd-helpdesk used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Walter CurtisSharePoint AED
Distinguished Expert 2018

Commented:
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?

Some more information would be helpful.. thanks

Author

Commented:
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.
Walter CurtisSharePoint AED
Distinguished Expert 2018

Commented:
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
Ok, based on this information - would you suggest upgrading the old server then moving over to the new one?
Nakul VachhrajaniTechnical Architect, Capgemini India

Commented:
The internal SQL exception reads:

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?
Tech Lead
Commented:
You may also get help from this step by step guide to Migrate from SharePoint 2010 to SharePoint 2013.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial