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

SharePoint Server reference architecture in AWS


SharePoint server reference architecture for public facing website scenario using Amazon AWS

Amazon Web Services Architecture Diagrams for Sharepoint
Amazon Web Services Architecture Diagrams for Sharepoint

 

SharePoint warmup script


Tired of waiting for SharePoint pages to load? Want something easy to support? That works on all versions?
Download SharePoint warmup script 

Key Features

Supports both SharePoint 2010 and 2013
Supports custom page URLs
Automatically detects all Web Application URLs
Downloads full page resources (CSS, JS, images) not just HTML
Downloads using Internet Explorer COM automation
Great for ECM websites to help populate blob cache
Warms up Central Admin too. Faster admin UI experience

https://spbestwarmup.codeplex.com/

Documentation Toolkit for SharePoint


With Documentation Toolkit for SharePoint you can generate farm documentation for your clients in a matter of minutes instead of hours. With the consultant subscription you can create documentation for unlimited number of farms

Features:

  • Generate SharePoint farm documentation
  • Explore configuration settings
  • Document passwords and product keys
  • Compare farms
  • Track farm changes
  • Automatic snapshots
  • Email notifications with configuration changes
  • Preview scheduled tasks

 Benefits:

  • Save time when documenting SharePoint farm
  • Standardized and professional looking documentation
  • Generate documentation for different farms and then compare
  • Detect misconfiguration of server farms
  • Easier farm management (with visualizations)
  • Maintain consistent settings across your DEV / QA / Staging / Production farmsSharePoint Documentation Toolkit