Archive for the ‘SharePoint 2010’ Category

Links to Free SharePoint 2010 Training Resources

June 25, 2012 Leave a comment

Lunch and Learn site –

Very corny videos – meant for user adoption, not training. There are good ‘How Tos’ after the videos.
Also has MySite introduction. All the Show me how videos use Office 2010.

Good case studies and business uses

Search overview is excellent.

 Training at your desk!

This is very good – but uses Office 2010 which might be different than what your users have.

Office Videos

The first two are the best ‘intro’ type videos.

SharePoint Ribbon
Team Work – docs, tasks, calendars

How to use with PowerPoint

Creativity Hub

This a SharePoint site you can host that has user directed training. Also has content for Office 2007 / 2010 so the site could be used for that too. The site remembers which courses each user has taken. Very good content.

Interesting Technical Training

Categories: SharePoint 2010 Tags: , ,

PowerShell Script to Backup Site Collections

May 2, 2012 2 comments

This script will create a backup for every site collection. The directory name  that contains the site collection backup is the GUID for site collection (the log file contains the mapping for GUID to URL). Make sure the backup location is shared so that the process can write.

This code shows how to remove particular site collections from the backup. It also prunes the number of backups that kept by deleting all backup folders older than 7 days.

# Backup all site collections in the farm, placing them in 
# a directory on a shared location
# Note - Does not backup the /train site collection
Add-PsSnapin Microsoft.SharePoint.PowerShell

# Take care of the disposable objects to prevent memory leak.
Start-SPAssignment -Global

# This is the backup path - must be shared

# Remove all that backup folders created > 7 days ago
get-childitem $backupLocation | 
     where {$_.Lastwritetime -lt (date).adddays(-7)} | 
     remove-item -recurse -Confirm:$false

# Get current date for use in log file and format it to avoid 
# invalid characters such as "/" and ":"
$today=Get-Date -format "MM-dd-yyyy"

# Create a folder in the backup location with todays date (sortable)
$todayFolder = $backupLocation + '\' + $((get-date).toString('MM-dd-yyyy'))
md $todayFolder

# Does not backup the /train site collection
# or the temporary web ap site collection on port 15702
foreach ($site in get-spsite -limit all | 
         where-object -FilterScript {$_.url -notlike "*/train*"} | 
         where-object -FilterScript {$_.url -notlike "*15702"}) {
    write-Host Start backing up $site to $todayFolder
    try {
         # Create a new backup file and name it based on current date.
         # If you want to create only 1 backup file and overwrite it
         # each time the backup is run, you can replace "$today.bak"
         # with your desired file name.
         $pathName = ($todayFolder + '\' + $($site.ID) + '.bak')
         write-Host 'Backing up ' $site ' GUID = ' $($site.ID)

         # This farm does not have Enterprise SQL Server, so snapshots 
         # cannot be used. This requires that the sites belocked for 
         # update during the backup, so this should be run after hours
         Backup-SPSite -Identity $site -Path $pathName -EV Err 
            -EA "SilentlyContinue"
         write-Host Backup succeeded.

         # Write success message to the log file
         write "$today $site GUID = 
           $($site.ID) successfully backed up.">>logFile
    } catch {
        write-Host Backup failed. See $logFile for more information.
        # Write error message to the log file
        $e = $Err[0].ToString()
        write "$today $site Error: $e">>logFile
Stop-SPAssignment -Global
Remove-PsSnapin Microsoft.SharePoint.PowerShell
write-Host "Finished script."
Categories: SharePoint 2010

Microsoft Project 2010 Bug – Save As PDF

February 6, 2012 Leave a comment

If you open an MS Project 2010 file (.MPP) from SharePoint, and try to save it as a PDF using the File > Save As menu, SharePoint opens the client File Dialog. If you select .PDF as the File Type, and then Save, the dialog closes, and a PDF options dialog opens. However, when you select OK on the PDF options dialog, the dialog closes normally BUT the PDF file is not created in the SharePoint document library from which the project was opened! Nor does it save anywhere on the client (that I can find).

The workaround is to use File > Save and Send > Create PDF/XPS Document.

This behavior is the same for MOSS / WSS 2007 and SharePoint 2010. File > Save As only appears to work for .MPP files (even if the name is changed). Using File > Save As with File Types XPS and Project Template files does not work either.

Cannot Upload, Add, or Edit Anything in a SharePoint Site

November 8, 2011 Leave a comment


If this happens, there can be two causes –

  • The content database has been set offline
  • The site collection has been set to read only

We had the latter happen when our virtual machine host crashed. Everything came back up correctly, but no one could add new documents or list items, or update existing ones. In our case, it was only on the main site collection. Other site collections on the same content database were not effected. Not sure, but the crash might have happened during a backup in which a PowerShell script locks each site collection before performing a site collection backup.

Check Site collection quotas and locks in Central Administration. Make sure you navigate to the offending site collection.