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
itd-helpdeskMSPAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Walter CurtisSharePoint AEDCommented:
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
itd-helpdeskMSPAuthor 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 AEDCommented:
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

itd-helpdeskMSPAuthor Commented:
Ok, based on this information - would you suggest upgrading the old server then moving over to the new one?
Nakul VachhrajaniTechnical Architect, Capgemini IndiaCommented:
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?
E ATech LeadCommented:
You may also get help from this step by step guide to Migrate from SharePoint 2010 to SharePoint 2013.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.