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
 
Advertisements

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/

SharePoint 2007 Central Administration – Operation


Central Administration > Operations

This page contains links to pages that help you manage your server or server farm, such as changing the server farm topology, specifying which services are running on each server, and changing settings that affect multiple servers or applications.

SharePoint 2007 Central Administration

Topology and Services

Servers in farm

Services on server

Outgoing e-mail settings

Incoming e-mail settings

Approve/reject distribution groups

Security Configuration

Service accounts

Information Rights Management

Antivirus

Blocked file types

Update farm administrator’s group

Information management policy configuration

Manage settings for single sign-on

Logging and Reporting

Diagnostic logging

Usage analysis processing

Information management policy usage reports

Upgrade and Migration

Microsoft Content Management Server migration

Enable Enterprise Features

Enable features on existing sites

Convert license type

Global Configuration

Timer job status

Timer job definitions

Master site directory settings

Site directory links scan

Alternate access mappings

Manage farm features

Quiesce farm

Solution management

Backup and Restore

Perform a backup

Backup and restore history

Restore from backup

Backup and restore job status

Data Configuration

Default database server

Data retrieval service

Content Deployment

Content deployment paths and jobs

Content deployment settings

Check deployment of specific content

Installing SP3 for SharePoint 2007


How to install Service Pack 3 for SharePoint 2007  Server?

1. Download and Install Service Pack 3 for Windows SharePoint Services 2007 (KB2526305), 64-Bit Edition
     http://www.microsoft.com/download/en/confirmation.aspx?id=27828

If you have multiple front end SharePoint servers, you need run Service Pack 3 in all servers

2. Download SharePoint 2007 SP3 for 64bit and install in your SharePoint 2007 server
    http://www.microsoft.com/download/en/details.aspx?id=27803

 Office System Servers Service Pack 3  

SharePoint 2007 SP3 Installation in process

Once the update is installed, you will get SharePoint product and technologies configuration wizard. Run the configuration
Wizard to install SP3 udpates

SP3 Upgrade for SharePoint 2007

image

You must run setup to install new binary files for every server in your server farm. If you have
multiple servers in your server farm, run setup and the configuration wizard on the other servers now,
and then return to this server and click OK to continue.

4. Restart your server

Download SharePoint 2007 SP3 for 64bit


Where to download SharePoint 2007 Service Pack 3 (SP3) for 64bit operating system?
You can download SharePoint 2007 SP3 for 64bit from : http://www.microsoft.com/download/en/details.aspx?id=27803