Archives For SharePoint 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

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