Archives For SharePoint 2007


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
 

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/


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


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


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


Reference to all STSADM operations to manage SharePoint 2007 farm.

  1. stsadm -o activatefeature {-filename <relative path to Feature.xml> | -name <feature folder> | -id <feature Id>} [-url <url>] [-force]
  2. stsadm -o activateformtemplate -url <URL to the site collection> [-formid <form template ID>] [-filename <path to form template file>]
  3. stsadm -o addalternatedomain -url <protocol://existing.WebApplication.URLdomain> -incomingurl <protocol://incoming.url.domain> -urlzone <default, extranet, internet, intranet, custom> -resourcename <non-web application resource name>
  4. stsadm -o addcontentdb -url <url> -databasename <database name> [-databaseserver <database server name>] [-databaseuser <database username>] [-databasepassword <database password>] [-sitewarning <site warning count>] [-sitemax <site max count>]
  5. stsadm -o adddataconnectionfile -filename <path to file to add> [-webaccessible <bool>] [-overwrite <bool>] [-category <bool>]

 

See full list: http://blogs.technet.com/b/josebda/archive/2007/03/22/complete-reference-of-all-stsadm-commands-with-options-in-moss-2007.aspx


Download the SP3 package from Microsoft Download Center

The following files are available for download from the Microsoft Download Center:

The 2007 Microsoft Office servers Service Pack 3 (SP3) and the 2007 Microsoft Office servers Language Pack SP3 provide the latest updates to the 2007 Office Servers and to the 2007 Office Servers Language Pack. This package includes 2007 Microsoft Project Server. These updates include two main categories of fixes: 

  • Previously unreleased fixes that were made specifically for this service pack. In addition to general product fixes, this includes improvements in stability, performance, and security.
  • All the public updates, security updates, cumulative updates, and hotfixes that were released through September 2011.
DownloadDownload the 32-bit 2007 Office Servers SP3 package now.


DownloadDownload the 64-bit 2007 Office Servers SP3 package now.


DownloadDownload the 32-bit Office Servers Language Pack 2007 SP3 package now.


DownloadDownload the 64-bit Office Servers Language Pack 2007 SP3 package now.


Steps of the migration from SharePoint 2007 to SharePoint 2010
Great step by step instructions: http://mosshowto.blogspot.com/2010/06/migrating-to-sharepoint-2010.html

1 – ugrading the SharePoint Farm with MOSS 2007 SP2
2 – upgrading the SharePoint Farm with MOSS 2007 October 2009 Cummulative Updates
3 – running the pre-upgrade tool: pre-upgrade checker
4 – Scenario 1: performing database attach upgrade with read-only databases
4.1 – Building a SharePoint 2010 Farm
4.2 – Determining how to handle customizations
4.3 – Moving the customization to the SharePoint 2010 Farm
4.4 – Moving and Upgrading the Content to the SharePoint 2010 Farm
4.5 – Restoring and Upgrading the Content on the SharePoint 2010 Farm
5 – Scenario 2: In-place upgrade with detached databases on a separate Farm
5.1 – Copying the MOSS 2007 farm to upgrade to 64-bit
5.2 – Performing an in-place upgrade to upgrade the farm and settings
5.3 – Moving the Content to the SharePoint 2010 Farm
5.4 – Restoring and Upgrading the Content on the SharePoint 2010 Farm
5.5 – Fixing the customizations.

Great step by step instructions: http://mosshowto.blogspot.com/2010/06/migrating-to-sharepoint-2010.html

increase mysite quota

September 9, 2011 — Leave a comment

How to change MOSS My Site quotas or increase my site quota for existing my sites?

1. Log into Central Administration
2. Click Application Management | Under SharePoint Site Management select Site Collections Quotas and locks

site_collection_quotas_and_locks

3. From Dropdown box, change Site Collection

change_site_collections

4. Search the user which you want to increase a quota

select_name

 

5. Select the user and from current quota template, select Individual Quota

select_individual_quota

Increase the my site storage amount and click OK

increase_my_site_storage_moss


I found a great post from : SharePoint: How to shrink transaction log file and
I was able to follow the instruction and successfully shrink transaction logs for SharePoint database without any problem. 

Here is the instruction to shrink transaction logs  files for SharePoint

  1. Change the database recovery model to SIMPLE using the next command:
    • ALTER DATABASE <Your Database Name> SET RECOVERY SIMPLE;

      shrink_transaction_logs_for_sharepoint

  2. Shrink the database or transaction log file using Microsoft SQL Server Management Studio:
    Right click on the database which you  altered to recovery simple and go to Task | Shrink | Database  It will take some time depend on on the size of database

    Shrink Transaction Log for SharePoint
    Or use the following command to shrink the transaction log file, for example, to 5 MB:

    • DBCC SHRINKFILE (<Your Database Name>_Log, 5);
  3. Set back the database recovery model to FULL using the next command:
    • ALTER DATABASE <Your Database Name> SET RECOVERY FULL;

      shrink_transaction_logs_for_sharepoint_recovery_full

If it’s not production database, you, in principle, can skip step 3 leaving the database recovery model in SIMPLE. Transaction log in this case will not grow. But note that some people complain that it can cause some problems while attempting to delete SiteCollection from SharePoint Central Administration. I’ve never been faced with such issue, but just in case keep FULL recovery model.

Source: SharePoint: How to shrink transaction log file


How to add a toolbar to custom List views?
Download source code and instructions to build a custom view list web part from Adding a Toolbar to Custom List Views


Using a  SharePoint URL Shortener from Codeplex you can shorten long SharePoint URL

Project Description
This SharePoint feature allows end-users to generate shortened URLs against SharePoint content that can be used in documents, emails, navigation links, etc.

SharePoint URL Shortener : All you to shorten SharePoint Long URL

SharePoint URL Shortener

Download SharePoint Shortener URL tool from CodePlex: SharePoint URL Shortener Tool


Enabling Microsoft Office SharePoint Server as the File System for Moodle

Safeguarding files saved in Moodle just got better.  As the title suggests, the white paper explains how IT Pros and partners can configure Moodles to use Microsoft SharePoint, a world class content management system, as the file system for all of their Moodle instances.  Moreover, IT Pros and partners do not have to develop or install any new code to enable this integration.

Read More: Enabling Microsoft Office SharePoint Server as the File System for Moodle


High Level Solution Archituecture for SharePoint from netApp, VMware and Cisco

If you need more info, please read : http://media.netapp.com/documents/tr-3785.pdf