Creating a Sharepoint 2010 Lab out of production

Posted on 2011-05-09
Last Modified: 2012-05-11
I have a Sharepoint 2010 farm which has:
2 WFE's
2 Application Servers
1 Backend SQL
3 Web Applications (Sharepoint Team Site, Mysites & BI Site)
Security = Kerberos

I am trying to create a lab environment just to test designing the Sharepoint Team Site & Mysites so built a single server with Sharepoint & SQL. Created 2 web applications for Team Site & Mysite. Backed up the content DB's from production, restored to test, changed security to Classic (not using Kerberos in lab) and attached to the 2 web apps.

I can get to the Mysite Web App but no content within the sites seem to work. When clicking on content, I get "You do not have permissions to have lists and pages within My Site." In addition, in Central Admin I see 23 site collections where there should be over 300.

I can't get to the Team Site application at all. Just get page can't be found. The attached content DB shows it has 5 site collections where it should over 30.

Is there an issue creating a lab on a single server when the original was larger or could Kerberos have something to do with it?

Question by:rparsons1000
    LVL 14

    Accepted Solution

    So answering your questions:

    Q:vIs there an issue creating a lab on a single server when the original was larger or could Kerberos have something to do with it?
    A: NO

    but you can't just backup and restore the content databases from one farm to the other and expect to automagically work :) .

    Go to the Central administration - > application  management - > content database
    delete the content database( that will remove the relationship of the SQL db with your SharePoint , it will not delete the database.)

    then reattach it using the Powershell script from the sp powershell console

    Mount-SPContentDatabase -Name YourDBname -DatabaseServer YourSQLServer -WebApplication http://YourWebAppName  -Updateuserexperience -ClearChangeLog

    give that a shot and see if they comeback online

    Best of luck

    LVL 5

    Author Closing Comment

    Ahhh, I did not think about using the powershell command. This server was actually used for pre migration testing from 2007 to 2010 so I also suspect it had some issues. I went ahead and just built another server, attached the DB and all is good. I will award full points though, this is good info.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Work Over Net is a new and very powerful collaboration product. With its new easy interface it is becoming very competitive to other similar products like webex and office interactive. WON 2010 have the standard business tools needed for multi-offic…
    Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    734 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

    19 Experts available now in Live!

    Get 1:1 Help Now