Tag Archive for SharePoint 2010 Administration

Cincy SPUG Presentation – November 3, 2011

SharePoint 2010 Attach Content Database – Alerts not working now FIXED

So I took a SharePoint 2007 SP2 compliant and tested content database and placed it into a SharePoint 2010 enviornment.  All the content was there.  The permissions were fine.  However, by database attachment went to a new SharePoint 2010 web application that had a different URL name.

Example:  intranet.company.com SP 2007 content database was attached to sp2010dev.company.com

This URL change throws off alerts.  You can delete the alerts and add them back in but that is just crazy to think about that scenario.  And guess what…..there is a PowerShell commandlet to fix this issue. But unfortately, this answer is buried on search engines.

Anyway, there is the PowerShell commandlet.

[box]Invoke-AlertFixup -site <NewURL> -oldurl <OldURL> [/box]

Here is the exact Technet article to reference.

A must have PowerShell statement inside your PowerShell Script for SharePoint 2010

The past few weeks, I have been writting a lot of PowerShell scripts so I can automate as many SharePoint administrative tasks that I can so I can enjoy other aspects of SharePoint during the business day.  🙂

I found a must have statement from the book, “PowerShell for Microsoft SharePoint 2010 Administrators“, book.

Here is the statement.  This statement is important if you have a scheduled task or a program that kicks off programs.

I have a template now to make sure I have this statement right underneath my opening comments area. 

[box type=”info”]Example: If (-not(Get-PSSnapin | Where-Object { $_.Name -eq “Microsoft.SharePoint.PowerShell”})) {Add-PSSnapin Microsoft.SharePoint.PowerShell;}[/box]