Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Copy current live Sharepoint 2010 environment and deploy in a test environment

Posted on 2013-01-08
Medium Priority
Last Modified: 2013-02-04
We have our live Sharepoint 2010 Farm. It is running off Server 2008 R2.
The Database Server is SQL 2008 R2. This is running on Server 2008 R2 also.
Both Servers are VM's.

We would like to replicate the current live environment to 2 new Server 2008 R2 VM's (1 with SP2010 and 1 with SQL 2008 R2) so we can use as a test farm to deploy and test a new feature.

Is there a way to backup the current farm, then deploy it on the 2 new servers? The new servers will be running in the same domain. So we would need to make sure that the live and test farms do not interact with each other. Is this possible?
Question by:Howzatt
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
  • 4
  • 2
  • 2
  • +2

Accepted Solution

Rahul Gupta earned 504 total points
ID: 38757783

Assisted Solution

by:Rahul Gupta
Rahul Gupta earned 504 total points
ID: 38757785

Assisted Solution

wdfdo1986 earned 996 total points
ID: 38757865
You can either use UI or Powershell commands
Powershell commandlets for backup and restore are
Backup-SPFarm and Restore-SPFarm

Use these official documentations
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

LVL 38

Assisted Solution

by:Justin Smith
Justin Smith earned 252 total points
ID: 38758594
After reviewing all these options that were posted, I have the following comments:

1. sharepointchick - this is a bit overkill.  You don't need to worry about that XML spit out for the accounts.  Also, I believe this was written for 2007, though the overall process is pretty much the same.

2. richardstd - this looked promising, but he's lacking information.

3. technet - the technet articles are all for backup/restore in SharePoint.  For one, the farm level backup and restore usally only works if you're restoring to the same server names.  Secondly, the site level backup and restore is pointless if you have a bunch of sites.  You'd have to run it for each one.

Rather than posting a link to an article, let me first ask you how many Site Collections does your farm have?  What is the average size per site?  Do you have a bunch of custom search configuration (rules, properties, etc) that you need to replicate?  Do you have a bunch of custom User Profile Properties that you need to replicate?

Author Comment

ID: 38761379
ACH1lLLES, Just want to replicate the entire farm. Do you need to know the answers to all of those questions to do that?

Assisted Solution

wdfdo1986 earned 996 total points
ID: 38761818
Replicate entire farm can be done by using BR methods given by UI or Powershell Commandlets.
But Site Collections should be separately backed up and restored.
Sorry I missed that point earlier.
But as far as I see your problem you don't need to replicate site collections in your test environment. Am I right?
If you want refer to official technet documents always. Because they are the most up to date.
LVL 14

Assisted Solution

KoenVosters earned 248 total points
ID: 38762705
Have you considered creating a VM of your AD, putting it together with the SharePoint Server and SQL on a seperate network segment so that it is completely seperated from the rest?

That way you will have the full stuff all together.

Another option would be to create a new farm in VM's, add the content databases and service application databases and deploy any custom solutions you already have on it.

It's a great way to test if you can recover your SharePoint farm from a backup (and test if all the customizations you have there are properly documented)

Afterwards you can, as a process, repeat the re-deployment of content databases from production to your test environment. Additionally, take into account that if you are using the MMS that also those databases need to be copied with the content databases as there is a GUID based link between the two.

Author Comment

ID: 38762744
Forgot to mention 1 point in the original post. There are 2 SP servers. 1 for App and 1 for Web.
What I have done so far:
* Deployed 3 new VM's (Server 2008 R2)
* Installed SQL 2008 R2 on Server A. Add all the appropriate users
* Installed SP2010 on Servers B & C
* Run a backup of the Content DB from the Production Farm SQL Server
* Restored the Backup to SQL on Server A

I assume the remaining steps are too:
* Create the new Farm on SP Server B.
* Connect SP on Server C to the Farm on Server B
* remove the default content DB from the new farm
* Attach the Content DB on Server A

This is the first time I have attempted this. I am not a SP Expert. So any other steps I am missing would be greatly appreciated.

Assisted Solution

wdfdo1986 earned 996 total points
ID: 38763497
First where did fails? I have never done it in that way.

If you want to go this way I recommend to backup and restore both config and content dbs and use this command to attach it
New-SPConfigurationDatabase -DatabaseName <Config DB Name> -AdministrationContentDatabaseName <Content DB Name> -DatabaseServer <SQL Server> -Passphrase (ConvertTo-SecureString <SQL Server Password> -AsPlainText -force) -FarmCredentials (Get-Credential)

This is the recommended command for DBA created DB scenario. So it should work.

Actually that's not the best way if you are not an SP expert. If you use commandlets or UI you don't have to worry about the DBs.

Assisted Solution

wdfdo1986 earned 996 total points
ID: 38763535
And also run the PS config after that.

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
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…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

730 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