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

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.

cpcitAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
Justin SmithSr. System EngineerCommented:
So if you look at the SQL server in your restored farm, did the DB's get created?
0
 
cpcitAuthor Commented:
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
 
cpcitAuthor Commented:
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
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
Justin SmithSr. System EngineerCommented:
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

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
Justin SmithSr. System EngineerCommented:
full farm restores in 2010 (as in 2007) still aren't a good way to duplicate environments.
0
 
cpcitAuthor Commented:
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
 
Justin SmithSr. System EngineerCommented:
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
 
cpcitAuthor Commented:
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
 
Justin SmithSr. System EngineerCommented:
Yeah, it has to be the same version.  Worst case, you would have to go from a lower to a newer version.
0
 
cpcitAuthor Commented:
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
 
Justin SmithSr. System EngineerCommented:
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
 
cpcitAuthor Commented:
even though i could not figure out why the farm backup/restore was failing, this method did the job. thanks a million .. :-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.