<div>
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?<br />
<br />
Some more information would be helpful.. thanks
</div>


<div>
<blockquote>
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?
</blockquote>
<br />
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. <br />
<br />
The error is what I get above.
</div>


<div>
Here is some information that may be helpful to you:<br />
<br />
<a href="https://technet.microsoft.com/en-us/library/cc263299.aspx" rel="ugc">https://technet.microsoft.com/en-us/library/cc263299.aspx</a><br />
<br />
<a href="http://www.falconitservices.com/support/KB/Lists/Posts/Post.aspx?ID=124" rel="ugc">http://www.falconitservices.com/support/KB/Lists/Posts/Post.aspx?ID=124</a><br />
<br />
Hope that helps...
</div>


<div>
Ok, based on this information - would you suggest upgrading the old server then moving over to the new one?
</div>


<div>
The internal SQL exception reads:<br />
<br />

<blockquote>
SqlException: Cannot alter the role 'db_owner', because it does not exist or you do not have permission.<br />
Cannot alter the role 'db_owner', because it does not exist or you do not have permission.
</blockquote>
<br />
From &nbsp;what I believe, the restore sequence is trying to add new logins and users to the db_owner role.<br />
<br />
Just to cross-check: Are you restoring the database with a login having sysadmin privileges on the SQL Server?
</div>


<div>
<div class="content wysiwyg-content">
Hi Guys,<br />
<br />
I'm trying to move Sharepoint 2010 to a new 2013 deployment but it is also on a new domain.<br />
<br />
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.<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/04_w16/1090931/BridgeSharepointRestoreLog.txt" target="_blank" class="file-inline" title="BridgeSharepointRestoreLog.txt (82 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>BridgeSharepointRestoreLog.txt</a>
</div>
</div>


BridgeSharepointRestoreLog.txt

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.

Sharepoint Restore Problems

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Microsoft SharePoint

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft server applications are those applications developed specifically, but not necessarily exclusively, on the Windows Server platform. In addition to well-known products like SQL Server, Exchange, Internet Information Services (IIS), Microsoft Dynamics, Forefront, Lync and Sharepoint, they include applications like Skype, BizTalk, Hyper-V, Groove and Commerce Server. Server applications are managed with the Microsoft System Center.

Microsoft Server Apps

IIS is Internet Information Services, the web server included with Windows Server operating systems. All current versions are built on a modular architecture; modules can be added or removed individually so that those required for specific functionality are installed. The full installation of IIS includes HTTP, security, content, compression, caching, logging and diagnostics.

Microsoft IIS Web Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.