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,897 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
[X]
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
  • 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

631 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