Solved

SharePoint testing of the same content database

Posted on 2011-03-25
4
381 Views
Last Modified: 2012-05-11
What are the best practices for SharePoint testing.  We have just one server and one SQL server but want to test some changes to our style sheets etc.   We have a product web application/content database running now which is working fine now.   We created a second web application for testing  We backup the content database from the production application and then restore it and mount it the error appears about orphan sites and the site id is used in this farm?   What is the best way to have a testing bed of your production data?
0
Comment
Question by:MainSail2007
  • 2
4 Comments
 
LVL 3

Accepted Solution

by:
awhughes earned 250 total points
ID: 35214380
Best practice is to have three environments, Development, Production and Test. Anything else, using seperate web apps but with the same shared services, is not a true test of the readiness of changes for production.

Specific development work should be done in isolation, crafting code in Visual Studio and using the Development SharePoint platform, which would normally just be a base vanilla setup. The Test environment should be a perfect copy of the Production environment. Finalised code and changes should be moved to Test, configured and then undergo functional testing. Once approved you can move the changes to Production and run through UAT.

Typically Dev and Test would be virtualised instances to reduce overhead. Test should be a VMWare or Hyper-V snapshot of the production environment and kept in step. Increasingly these days developers prefer to have an individual Development environment (Visual Studio, SharePoint) running locally on their workstation with a VM of SharePoint.

That's my understanding of current best practice. Obviously there's a cost associated with this but it is worth investigating an MSDN subscription to cover the server licenses.

Hope that's of use.

A
0
 
LVL 14

Assisted Solution

by:KoenVosters
KoenVosters earned 250 total points
ID: 35215283
Can only confirm what awhughes is saying. If you want to do it in one farm, you are exposing your production farm to risks that you do not want it to be exposed to. Have you made the calculation of what effort it would cost to bring back up the production environment if you mess it up compared to a seperate testing environment?
0
 

Author Comment

by:MainSail2007
ID: 35215837
I do appreciate the advice that I received but I do have one remaining question; why would the system not allow me to have two web applications?    Backing up and restoring the database to a different name and then creating a web application to use that database?   It would seem logical to use it that way but the error states that the side id is in use?

0
 
LVL 14

Expert Comment

by:KoenVosters
ID: 35215917
It is not very logical to have the same content twice on the same environment. The reason it states the site id is already in use is because the site id is stored in the configuration database. As you are addin the content database to the same farm the site id already exists as there is one configuration database for the entire farm.

This is also the reason moving the content database to another farm will work just fine as it will be using other ids. If you really want to test it, you can create a new web application and use backup-restore of the site collection on that new web application.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sharepoint Backup and Restore individual files 4 59
Resize an Image Before Upload to SharePoint List using REST API 1 82
Date Differences SSRS 3 59
VBA in SharePoint 3 39
I have just recently built a new SharePoint 2007 farm on a complete Windows 2008 R2 server platform and part of my standard build procedure is to implement a warm up routine, usually in the form of a script that is scheduled every morning to launch …
Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

920 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now