Solved

SharePoint testing of the same content database

Posted on 2011-03-25
4
383 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

830 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