Question

Ramshna on Tue, 09 Dec 2014 20:26:20


Sharepoint 2010 Question

I was in a debate with a colleague about sharepoint restore. I understand that there are bunch of things that need to be backed up like GAC, hive, etc but we do not have complex apps. We are using sharepoint as internal portal and there are external facing sites which just disseminate information. 

So the debate was if I backup the content DB of form A webapp  and create a new web app on Farm B and restore Farm A content DB on to Farm B content DB , will that work. 

What is the importance of service application DB's. Is it ok if I just turn on service applications related to this webapp on Farm B or do I need to restore the DB's too. 

I understand the search and managed metadata service DB's ,,,Can you please give me examples of other services for which DB needs to be backed and restored. 


@R


Sponsored



Replies

The Grim on Tue, 09 Dec 2014 20:42:58


if you don't back up the app server you will have issues with service accounts and web configs for the farm solution itself.

Recommended to take backup of both app and DB, the content db will give you most of the content you are looking for but you will struggle with functionality until you re-register other supporting services and service proxies to work with it.

Ramshna on Tue, 09 Dec 2014 22:29:47


Do you have any specific examples/articles regarding issues with service accounts

Lisa Chen1226 on Fri, 19 Dec 2014 02:54:38


Hi,

Based on your description, my understanding is that you want to restore Content Database to a different farm.

Here are two similar posts, you can use as a reference:

http://sharepoint.stackexchange.com/questions/10325/restore-content-database-to-a-different-farm-prod-beta-dev-servers

https://social.technet.microsoft.com/forums/sharepoint/en-US/72410205-1720-4a96-964a-29ac094fa505/sharepoint2010-issue-site-collection-for-content-database

For more information, refer to the following links:

http://technet.microsoft.com/en-us/library/dd207294(v=office.14).aspx

Best Regards,

Lisa Chen

AnilSharma4 on Fri, 19 Dec 2014 03:53:36


HI Ramsha,

I am ok with you about content db back up from FARM A to FARM B.

one more things that you need to check the Farm version and based on that you can downlaod the service pack and patch to your new version

and you need to take backup of all content db and other service application dB to restore the new FARM

and veryfy all the service application and any workflow as you created in share point design

https://social.technet.microsoft.com/forums/sharepoint/en-US/72410205-1720-4a96-964a-29ac094fa505/sharepoint2010-issue-site-collection-for-content-database


This article describes how to move all of the databases associated with Microsoft SharePoint Server 2010 from one database server to another database server. If your databases are hosted on different servers, this procedure applies to the database server that hosts the configuration database. For moving content databases only

http://technet.microsoft.com/en-us/library/cc512725%28v=office.14%29.aspx

You can check this link which can give more information about service application

Rename or move service application databases (SharePoint Server 2010
http://technet.microsoft.com/en-us/library/ff851878%28v=office.14%29.aspx


Please mark Answer and Vote me if you think that it will help you to resolved your issue