Migrate a content database from SharePoint 2007 to 2010


Migrate a content database from SharePoint 2007 to 2010

BACK UP YOUR 2007 CONTENT DATABASE

Back up your 2007 content database from SQL Management Studio on the SharePoint 2007 server, and put the backup file somewhere it is accessible from the new SharePoint 2010 Server instance.

Backup SharePoint Content Database from SQL Server

RESTORE THE 2007 CONTENT DATABASE TO THE SHAREPOINT 2010 DATABASE INSTANCE

Connect to the SQL Server Instance hosting your SharePoint 2010 installation’s databases.  Restore the wss_content database from the backup file created in the step above.

DETATCH ANY CONTENT DATABASES FROM THE TARGET WEB APPLICATION

In Central Administration –> Application Management, select “Manage Content Databases” under the Database heading.

Select the target web application in the “Web Application” drop-down box at the top left, if it is not already ­­­

Ensure there are no content databases for the target web application.  If the list contains any content databases, click on each content database name.  On the “Manage Content Database Settings” screen, select the “remove content database” checkbox and click OK.

Remove Content Database from SharePoint Site

RUN THE POWERSHELL TEST-SPCONTENTDATABASE CMDLET

Launch the SharePoint 2010 Management Shell available under Start->Programs –> Microsoft SharePoint 2010 Products. 

Run the Test-SPContentDatabase command from the SharePoint 2010 Management Shell PowerShell window with the following syntax:

Test-SPContentDatabase –Name your_content_db –WebApplication http://YourSiteName

RESTORE THE CONTENT DATABASE USING STSADM.EXE

Using the stsadm.exe tool, run the addcontentdb command using the syntax below:

stsadm -o addcontentdb -url http://YourSiteURL -databasename your_content_db -databaseServer YourDatabaseServer

PowerShell Command

Mount-SPContentDatabase "<ContentDb>" -DatabaseServer "<DbServer>" -WebApplication http://SiteName
 

Publishing Portal Missing Team Site Template


Publishing Portal Missing Team Site Template

Cannot find the “Team Site” template when I try to create a new site in SharePoint 2010
I checked Site Collection Administration | Features and all the features I needed are active

clip_image002

Went to Site Settings | Features and Team Collaboration Lists are active

clip_image004

Still when I try to create new site, I don’t see any Team Site templates

clip_image006

Solution:

Go to Site Action | Site Settings | Page Layouts and Site Templates

clip_image008

Select Team Site (ALL) and Add. Click OK below to add all the Team Sites

clip_image010

Now if you go to create sites, you will see the team sites template

clip_image012

PowerShell Command Builder for SharePoint


How to build PowerShell script in easy way for SharePoint?
Use PowerShell builder to create script for your SharePoint Farm Administration

SharePoint 2010/2013 Web Performance and Load Testing


Read More: Web Performance and Load Testing SharePoint 2010 and 2013 

  1. Create a new web performance and load test project. On the Visual Studio Ultimate menu, chooseFile, New, and then Project. Expand either Visual C# or Visual Basic and choose Test. Choose Web Performance and Load Test Project and choose OK.
  2. The Web Performance Test Editor displays with a blank test. To record the test, choose the Add Recording button.

    Add recording

  3. A new blank web browser window appears with the web test recorder panel on the left side. Enter the name of your SharePoint site in the browser address bar. Visual Studio Ultimate will record and list the URLs in the web test recorder panel.

    Web Performance Test Recorder

  4. Perform the following steps to navigate to the SharePoint sub site SampleSite and add a new item to the site task list:
    1. Choose SampleSite from the top of the SharePoint site.

      Choose SampleSite

    2. From the menu on the left side, choose Tasks.

      Choose Tasks

      The SampleSite > Task: All Tasks page appears.

    3. To add a new task to the list, choose the Add new Item link.

      Add new item

      The Tasks – New Item dialog box appears. The only required field is Title and the value entered does not matter. Complete the information on the dialog box and choose Save.

      Create new task item

    4. The web browser returns to the SampleSite > Tasks: All Tasks, which now lists the new task added in the previous step.

      New task added

    5. To end the recording, choose Stop on the Web Test Recorder panel.

      The Dynamic Parameter detection dialog box appears. It indicates detection progress. This should only take a short while to complete.

      Dyanmic parameter detection

      Visual Studio Ultimate will return you to the Web Performance Test Editor where your newly created web performance test is displayed.

      Web Performance Test Editor

  5. To confirm that the test is running correctly, first browse the SharePoint site to view the existing list items:

    http://sp2010/SampleSite/Lists/Tasks/AllItems.aspx

  6. Return to Visual Studio Ultimate and choose the Run test button on the Web Performance Test Editor. Your test runs, performing your recorded actions to add a new item to the task list in SharePoint.

    Run web performance test

  7. Choose refresh on the browser window with your SharePoint site and you should now see a new task item added to the list.

    Read More: Web Performance and Load Testing SharePoint 2010 and 2013 

Famous SharePoint URLs & Locations


Some times you want to jump right to a specific system list, page or go to the edit mode in a SharePoint site. I wanted to list all the famous urls I used for the past years and ask you to tell me about any other ones you know to add it here in the list:

Sign in as a different users
/_layouts/closeConnection.aspx?loginasanotheruser=true
Enable SharePoint designer
/_layouts/SharePointDesignerSettings.aspx

Welcome Page (Default page settings)
/_layouts/AreaWelcomePage.aspx

Change Site Master Page
/_layouts/ChangeSiteMasterPage.aspx

Page Layouts and Site Templates
/_Layouts/AreaTemplateSettings.aspx

Master Pages library
/_catalogs/masterpage/Forms/AllItems.aspx

User Information List
_catalogs/users/simple.aspx

Quick Deploy List
Quick%20Deploy%20Items/AllItems.aspx

Open Page in Edit Mode
?ToolPaneView=2

Taxonomy Hidden List (MMS)
Lists/TaxonomyHiddenList/AllItems.aspx

User Information List:
_catalogs/users/simple.aspx

Force displaying the user profile in the site collection:
/_layouts/userdisp.aspx?id={UserID}&Force=True