Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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,830 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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
 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

A question that is asked often, is how to generate sequential numbers in InfoPath Forms. The best way to achieve this is to use a SQL database, along with a stored procedure and a web service to connect Forms Services to the DB. The first thing t…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

856 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