Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4938
  • Last Modified:

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.

0
cpcit
Asked:
cpcit
  • 6
  • 6
1 Solution
 
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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 6
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now