Solved

How to restore sharepoint 2010 backup to a different farm (running on different server on same domain)

Posted on 2010-11-10
12
4,786 Views
Last Modified: 2012-05-10
I am trying to restore a sharepoint 2010 backup(of a farm that has 1 database server and another server as Application+IIS server) to another farm installation(not standalone) (on a single server running DB+IIS+Application )?
I've tried the restore option from CentralAdmin by selecting 'Restore as New Configuration", but keep getting errors like some services failed on restore
Object WSS_Content failed in event OnRestore.
For more information, see the spbackup.log or sprestore.log file located in the backup directory.
SPException: The specified component exists. You must specify a name that does not exist.

Object Application_Registry_Service_DB_c9f7ea0083124a3282090764496e9a60 (previous name: Application_Registry_Service_DB_1414bc5aa49540fbb5b62caca59b7e1a) failed in event
OnRestore. For more information, see the spbackup.log or sprestore.log file located in the backup directory.
SPException: The specified component exists. You must specify a name that does not exist.
--- --- --


Please advise. My intention is to have a development farm where i can replicate everything (web Applications) on Production farm, but with a different URL.

0
Comment
Question by:cpcit
  • 6
  • 6
12 Comments
 
LVL 38

Expert Comment

by:Justin Smith
ID: 34102718
So if you look at the SQL server in your restored farm, did the DB's get created?
0
 

Author Comment

by:cpcit
ID: 34102861
no.
few points here. the farm(where I am trying to restore) has a set of DBs{WSS_Content. search_DB,Business xx etc etc) which gets created when i ran the configuration wizard after installing sharepoint 2010. But on running the restore from the CA, no additonal DBs(with the names i specified in my restore as NEW CONFIGURATION page) are getting created.
user account used by Farm and the user account used by various services(search,metadata etc) all are added as SQL admins, just to rule out any rights issue preventing the restore.
0
 

Author Comment

by:cpcit
ID: 34102884
just another thought, can I do a backup on my web app on my production farm and restore it (with different Url/ but with all other functionalities) on my development farm ?
(as my intention is to get a development farm which is a replica of web application(s) I have on my production farm)
pls advise.
0
 
LVL 38

Accepted Solution

by:
Justin Smith earned 250 total points
ID: 34102915
Yes.

Or you can simply create the web apps in your restore farm, then restore the databases from Prod through SQL.  Then you'll have to adjust the security on the db's in SQL.
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 34102926
full farm restores in 2010 (as in 2007) still aren't a good way to duplicate environments.
0
 

Author Comment

by:cpcit
ID: 34103037
On 'web app creation on development farm and restore DB through Sql from production farm' option, which DB are we talking about for restore? the content database(for my required web app on production env') alone or others (like search_db,metadata service_dbs, other service db_s etc)? also to be part of restore?
can u also explain what u mean by 'adjust security on Db's while restoring
[
the accounts used by Farm (a sharepoint managed account)(eg:SP_Farm) ,   services on farm, etc are same on my development and production farm
]
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 38

Expert Comment

by:Justin Smith
ID: 34104161
just the content db's for your web apps.  Don't worry about search and other service apps (except maybe MetaData if you are using that).

You'll need to make sure the web app pool account has owner access to the content database after you restore it in sql.  
0
 

Author Comment

by:cpcit
ID: 34130716
jfyi
i'm having issues restoring SQL db from production farm (which is Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)   ) and the test/development farm 's DB is [Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64) ] . give me a day or 2 to try your solution (and hence the delay in closing the call). (do you think such a SQL version diff. is an issue while restoing DB)
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 34133070
Yeah, it has to be the same version.  Worst case, you would have to go from a lower to a newer version.
0
 

Author Comment

by:cpcit
ID: 34167292
Restoration does work (upon recreating the webApp on the development farm and then restoring its WSS_content Db with the one from live farm), but this does not restore the web parts in use on live farm . will those have to be reconfigured manualy?
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 34167627
if they are custom, you probably need to install them in your test environment.  some web parts put files on the server file system, which obviously dont come over in a db restore.
0
 

Author Closing Comment

by:cpcit
ID: 34181655
even though i could not figure out why the farm backup/restore was failing, this method did the job. thanks a million .. :-)
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now