Site Recycle Bin (Microsoft IT Site Delete Capture) for Microsoft SharePoint Foundation and Microsoft SharePoint Server 2010 Frequently Asked Questions

Question:

Will the Microsoft IT Site Delete Capture available at www.codeplex.com/governance work with SharePoint 2010?

Answer:

Yes.

Question:

In Microsoft SharePoint Foundation and Microsoft SharePoint Server 2010 there is a Timer Job Definition called Gradual Site Delete, will the Microsoft IT Site Delete Capture work when this Timer Job Definition is enabled and what is this Timer Job Definition?

Answer:

Yes, the Microsoft IT Site Delete Capture will work with the Gradual Site Delete Timer Job Definition.

The Gradual Site Delete Timer Job Definition is designed to mitigate the impact of large site deletion in Microsoft SharePoint Foundation and Microsoft SharePoint Server 2010 environments.  Specifically as an example in Microsoft Office SharePoint Server 2007, when a site was deleted it called a stored procedure, proc.DeleteSite which walked through all of the tables in the content database and deleted the rows corresponding to the Id of the site being deleted, as a result up to 35 tables were touched as part of the site deletion process as a single transaction.  Knowing this delete operations will take a lock on the deleted rows and if the number of deleted rows exceeds a specific threshold, by default 5,000, SQL Server, in some cases, in the interest of efficiency will escalate the row locks to table locks – referred to as lock escalation.  Lock escalation will prevent user requests on the entire table which can leave the server unresponsive.

The Gradual Site Delete Timer Job Definition resolves this issue through implementing a process by which when a site collection is deleted the site entry (pointer) in dbo.SiteMap is removed from the configuration database and from dbo.Sites in the corresponding content database.  From an end user experience the site is deleted  and all access through the site Url in addition to its content is unavailable.  From this point the site deletion is then queued into dbo.SiteDeletion in the host content database where it is marked to be gradually deleted, this is where the Gradual Site Delete Timer Job Definition comes into play.  The Timer Job Definition [Gradual Site Delete] executes on a Daily schedule [configurable], and will continuously attempt to delete all the data for all the sites in its queue (dbo.SiteDeletion). It will delete the data in batches of a maximum of 1000 rows through multiple transactions to avoid escalation and can be resumed  in the event any failure occurs so that it can attempt the delete process again if required, once the site is completed deleted the dbo.SiteDeletion entry is removed.

Since the SiteDeleted event on which the Microsoft IT Site Delete Capture depends is called prior to calling the stored procedures there is no impact its the logic.

The Experts Conference 2010

Session abstracts and keynotes have been announced for the 2010 Experts Conference in Los Angeles, CA.

The Experts Conference (TEC) 2010 marks the first ever SharePoint training curriculum for TEC and includes industry recognized speakers and trainers from across the globe providing deep technical sessions to include, but not limited to upgrade and migration, social computing, enterprise and web content management, development, security, and authentication  (see also http://tec2010.com/agenda-speakers/sharepoint-training/session-abstracts/ for a sample of session abstracts). 

To learn more about SharePoint training at TEC2010 visit http://tec2010.com/general-information/sharepoint-training/ or for additional information on registration and special registration discounts available through January 1st, 2010 see below.

Dates: April 25-28

Location: JW Marriott Hotel Los Angeles at L.A. Live

Details: SharePoint The Experts Conference

Registration:  https://register.crgevents.com/TEC2010/Register/Login/default.aspx

SharePoint Joel $500 Discount $1345 USD conference registration price ($200 off regular + additional $300 off)

Joel has negotiated a special SharePoint discount available through January 1st, 2010.  To take advantage of this offer visit the registration page here https://register.crgevents.com/TEC2010/Register/Login/RegCode.aspx and enter the code ATGNVET.  When prompted about how you heard about the conference, select Quest Staff and enter Joel Oleson.

Press Release: “Quest Software Unveils The Experts Conference 2010 Keynotes” – Microsoft Technology Leaders Conrad Bayer, Alex Weinert, Konstantin Ryvkin, and Bill Baer to Keynote Directory & Identity, Exchange and SharePoint Event in Los Angeles.

Recommended Upgrade Resources for Microsoft SharePoint Foundation and Server 2010

Upgrading is common function with Microsoft SharePoint Products and Technologies, whether it be product specific such as Service Packs and Cumulative Updates or platform specific such as new versions of products or the core operating system.  Prior to upgrading to any version of a product or patching and updating that product you should understand both the process and options and available to you. 

This post provides recommended upgrade resources related to Microsoft SharePoint Foundation and Server 2010 and the technologies on which depends separated by both Documentation and Tools resources because I hate looking for this stuff myself.  😉

Contents

Microsoft Office SharePoint Server 2007 Resources

Microsoft SharePoint Server 2010 Resources

Windows Server 2008 Resources

Windows Server 2008 R2 Resources

SQL Server 2005 Resources

SQL Server 2008 Resources

Microsoft Office SharePoint Server 2007 Resources

Documentation

Deploy Software Updates for Office SharePoint Server 2007

Provides information about software updates is aimed at all IT professionals who maintain Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server 2007  in addition to specific instructions for installing a software updates on Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server 2007.

Tools

preupgradecheck STSADM Command Line Operation

The STSADM preupgradecheck command line operations runs rules that are intended to assist administrators in preparing for upgrade from Windows SharePoint Services 3.0 and related products to future version of SharePoint and Technology products.

List of all Windows SharePoint Services and SharePoint Server Pre-Upgrade Checker Knowledge Base Articles

Contains a list of all Pre-Upgrade Checker for Windows SharePoint Services 3.0 Service Pack 2 knowledge base articles. The Pre-Upgrade Checker ships in Windows SharePoint Services 3.0 Service Pack 2. It is used to assess the server for potential upgrade issues when you prepare to upgrade to the next version release that supersedes Windows SharePoint Services and SharePoint Server 2007.

exportIPFSadminobjects STSADM Command Line Operation

Extract InfoPath Forms as WSP (solution packages).

SharePoint Diagnostics Tool

The SharePoint Diagnostic Tool, included with the latest release of the SharePoint Administration Toolkit, was created to simplify and standardize troubleshooting of SharePoint Products and Technologies, and to provide a unified view of collected data; however, while commonly used reactively for analytical purposes to narrow the source of a particular problem, can also be used proactively to inventory the current environment and address issues prior to upgrading future version of SharePoint and Technology products.

Microsoft SharePoint Server 2010 Resources

Documentation

Microsoft SharePoint Server 2010 Installation, Upgrade, and Getting Started

Download Microsoft SharePoint Server 2010, locate links to resource centers, and references as related to planning, deployment, operations, and technical guidance for Microsoft SharePoint Foundation and Server 2010.

Determine Upgrade Approach

Describes the available upgrade approaches available to Microsoft SharePoint Server 2010.

Upgrading to SharePoint Server 2010

Describes the available upgrade approaches and provides planning and scenario-based  resources.

Microsoft SharePoint Server 2010 Setup, Upgrade, Operations, Administration Forum

Discuss topics related to setup, upgrade, operations, and administration with Microsoft and community members.

Windows Server 2008 Resources

Documentation

Installing Windows Server 2008

Provides information about installing the Windows Server 2008 operating system. It also provides information that you can use to troubleshoot problems that may occur during the installation.

Upgrading to Windows Server 2008

Provides important information about upgrading to the Windows Server 2008 operating system, including links to related documents with information about:

  • How to upgrade
  • Supported scenarios
  • Frequently asked questions
  • Known issues about the upgrade process

Guide for Upgrading to Windows Server 2008

Provides information about upgrading to the Windows Server 2008 operating system including how to upgrade, supported scenarios, frequently asked questions, and known issues about the upgrade process.

Known Issues When Upgrading to Windows Server 2008

Provides solutions for known issues that you may experience after you upgrade to Windows Server 2008.

Windows Server 2008 Service Pack 2 Deployment Guide

Provides information for IT administrators who are deploying Windows Server 2008 Service Pack 2. This document includes technical information, procedures, and recommendations for installing Service Pack 2 in a business or corporate environment.

Windows Server 2008 Service Pack 2 Frequently Asked Questions

Provides answers to common questions about this release of Windows Server 2008 Service Pack 2 and Windows Vista Service Pack 2.

Installing Windows Server 2008 with Service Pack 2

Provides information about installing the Windows Server 2008 operating system with Service Pack 2. It also provides information that you can use to troubleshoot problems that may occur during the installation.

Windows Server 2008 R2 Resources

Documentation

Installing Windows Server 2008 R2

Provides information about installing the Windows Server 2008 R2 operating system, including any known issues that you may need to work around before starting an installation. It also provides information that you can use to troubleshoot problems that may occur during the installation

Windows Server 2008 Upgrade Paths

Outlines supported and unsupported upgrade paths for editions of the Windows Server 2008 R2 operating system.

SQL Server 2005 Resources

Documentation

SQL Server 2005 Upgrade and Technical Reference Guide

Contains guidance for SQL Server administrators, developers, and IT decision makers who would like to move their SQL Server 2000 or 7.0 databases to SQL Server 2005.

SQL Server 2005 Upgrade Handbook

Provides information about the upgrade process, scenarios, competitive features, and ROI.

Set the Stage for a Smooth Upgrade (Microsoft SQL Server 2005)

Provides information about the upgrade process, common issues, and planning.

SQL Server Setup & Upgrade Forum

Discuss topics related to setup, upgrade, operations, and administration with Microsoft and community members.

Upgrading to SQL Server 2005 Frequently Asked Questions

PDF formatted documented providing 15 responses to frequently asked questions about upgrading to SQL Server 2005.

SQL Server 2005 Upgrade Planning

PowerPoint Presentation discussing upgrade topics to include why, how, planning, execution, best practices, and post upgrade execution steps.

Tools

SQL Server 2005 Upgrade Advisor

The Microsoft SQL Server 2005 Upgrade Advisor analyzes instances of SQL Server 7.0 and SQL Server 2000 in preparation for upgrading to SQL Server 2005, identifies feature and configuration changes that might affect your upgrade, and provides links to documentation that describes each identified issue and how to resolve it.

SQL Server 2008 Resources

Documentation

SQL Server 2008 Upgrade and Technical Reference Guide

Contains guidance for SQL Server administrators, developers, and IT decision makers who would like to move their SQL Server 2000 or 2005 databases to SQL Server 2008.

How to Upgrade to SQL Server 2008

SQL Server 2008 Books Online articles related to upgrade and migration.

Upgrading to SQL Server 2008

Provides planning information and resources to assist with the upgrade to SQL Server 2008.

SQL Server Setup & Upgrade Forum

Discuss topics related to setup, upgrade, operations, and administration with Microsoft and community members.

How to Troubleshoot a Failed Upgrade to SQL Server 2008

Knowledge Base article providing information on how to recover from a failed SQL Server 2008 upgrade.

SQL Server 2008 Service Pack 1 Setup Documentation

Setup documentation for SQL Server 2008 Service Pack 1.

Creating a Merged Slipstream Drop Containing SQL Server 2008 and SQL Server 2008 Service Pack 1

Provides information on how to create new source media that will slipstream the original source media and SQL Server 2008 Service Pack 1.

Tools

SQL Server 2008 Upgrade Advisor

The Microsoft SQL Server 2008 Upgrade Advisor analyzes instances of SQL Server 2000 and SQL Server 2005 in preparation for upgrading to SQL Server 2008, identifies feature and configuration changes that might affect your upgrade, and provides links to documentation that describes each identified issue and how to resolve it.

Running the Microsoft SharePoint 2010 Products Preparation Tool with Local Paths on Machines without Internet Connectivity

One of the questions I’ve received on a few occasions to date is how to run the Microsoft SharePoint 2010 Products Preparation Tool on a machine that does not have a connection to the Internet.

There are two possible methods to working around this scenario:

Manually download on another machine and then install the prerequisite software and configure the Server Roles, Role Services, and Features accordingly. 

See the following posts that describe the prerequisite software and accompanying download locations in addition to configuring the required Server Roles, Role Services, and Features for Microsoft SharePoint Foundation and Server 2010.

Configuring the Web and Application Server Roles for Microsoft SharePoint Foundation and Server 2010

Installation Notes for Microsoft SharePoint Server and Microsoft SharePoint Foundation 2010 Beta

The second option is to create and implement an installation file that specifies local or network paths to be used by the Microsoft SharePoint 2010 Products Preparation Tool:

Create the file PrerequisiteInstaller.Arguments.txt and specify the local or network path of the software to be installed that was downloaded through the links provided in the links above.

Create a new text document PrerequisiteInstaller.Arguments.txt in a text editor (Notepad).

Open PrerequisiteInstaller.Arguments.txt and specify the custom paths using the following examples:

/W2K8SP2:<path>

/NETFX35SP1:<path>

/PowerShell:<path>

/WindowsInstaller:<path>

/IDFX:<path>

/Sync:<path>

/ChartControl:<path>

/FilterPack:<path>

/ADOMD:<path>

/SQLNCli:<path>

A single space should separate each switch and argument, I.e. /NETFX35SP1:<path> /WindowsInstaller:<path>.  For additional help see the example below:

For example:

/NETFX35SP1:”\<server><share>dotnetfx35.exe” /IDFX:”\<server><share>MicrosoftGenevaFramework.x64.msi”
/ChartControl:”\<server><share>MSChart.exe” /sqlncli:”\<server><share>sqlncli.msi”
/Sync:”\<server><share>Synchronization.msi” /WindowsInstaller:”\<server><share>Windows6.0-KB942288-v2-x64.msu”

Save PrerequisiteInstaller.Arguments.txt to the directory where PrerequisiteInstaller.exe resides and run PrerequisiteInstaller.exe or run PrerequisiteInstaller.exe from the Command Prompt and append with the arguments used in PrerequisiteInstaller.Arguments.txt. 

PrerequisiteInstaller.exe will use the paths specified in PrerequisiteInstaller.Arguments.txt or the Command Prompt arguments when installing the software prerequisites for Microsoft SharePoint Foundation and Server 2010.

For additional help using the Microsoft SharePoint 2010 Products Preparation Tool from the Command Prompt run PrerequisiteInstaller.exe /?.

Common Microsoft SharePoint Server 2010 Installation Issues and Resolutions

I’ve been following the SharePoint 2010 Forums and have noticed several common installation issues.  These issues and possible steps to resolve those issues are included here.

ISSUE #1:  when running the SharePoint 2010 Products Configuration Wizard you may experience the error:

Failed to create the configuration database.
An exception of type System.Security.Cryptography.CryptographicException was thrown.  Additional exception information: The data is invalid.

To resolve the issue you can perform the following steps:

Modify the ACL on the 14 directory under %commonprogramfilesMicrosoft SharedWeb Server Extensions.

  1. Right-click on the folder %commonprogramfiles%Microsoft SharedWeb Server Extensions14, and then select the Security tab.
  2. On the 14 Properties dialog under the Security tab, select Edit.
  3. On the Permissions for 14 dialog click Add… and enter Network Service in the Enter the object names to select and then click OK.
  4. On the Permissions for 14 dialog select Full Control under Permissions for NETWORK SERVICE and click OK.
  5. On the 14  Properties dialog click OK.

NOTE

The previous steps are applicable only prior to running the SharePoint 2010 Products Configuration Wizard.  If you have run the SharePoint 2010 Products Configuration Wizard, follow the steps below:

  1. Open an elevated Command Prompt and change directories to %commonprogramfiles%Microsoft SharedWeb Server Extensions14 and enter psconfig –cmd –configdb disconnect to disconnect from the current configuration database.
  2. Open SQL Server Management Studio or SqlCmd and delete the existing configuration database.
  3. Follow the previous steps to modify the ACL on the 14 directory and run the SharePoint 2010 Products Configuration Wizard to create and configure the server farm.

NOTE

In the event the steps above do not immediately resolve the issue, open the Registry Editor and  delete the "SOFTWAREMicrosoftShared ToolsWeb Server Extensions14.0SecureFarmAdmin" Registry key and then run the SharePoint 2010 Products Configuration Wizard.

ISSUE #2:  when running the SharePoint 2010 Products Configuration Wizard you may experience the error:

An exception of type Microsoft.Office.Server.UserProfiles.UserProfileException was thrown.  Additional exception information: Unrecognized attribute ‘allowInsecureTransport’. Note that attribute names are case-sensitive. (C:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions14WebClientsProfileclient.config line 56).

To resolve the issue you can perform the following steps:

Download and install KB976462 from http://support.microsoft.com/kb/976462 for Windows Server 2008 R2 or KB971831 from http://code.msdn.microsoft.com/Project/Download/FileDownload.aspx?ProjectName=KB971831&DownloadId=7285 for Windows Server 2008 and run the SharePoint 2010 Products Configuration Wizard.

ISSUE #3:  when running Setup.exe for Microsoft SharePoint Server 2010 you may experience the error:

Setup is unable to proceed due to the following error(s):
A system restart from a previous installation or update is pending. Restart your computer and run setup to continue.
For the list of pre-requisites needed to install the product please refer to:
http://go.microsoft.com/fwlink/?LinkId=106209
Correct the issue(s) listed above and re-run setup.

Check the value of the following Registry keys:

HKEY_LOCAL_MACHINESOFTWAREMicrosoftUpdatesUpdateExeVolatile – if the value of the UpdateExeVolatile Registry key is anything other than 0 you will see this message.

HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlSession ManagerPendingFileRenameOperations – if the PendingFileRenameOperations Registry key has any value you will see this message.

To remove an orphaned UpdateExeVolatile registry key value

  1. Open a registry editor, such as Regedit.exe or Regedt32.exe.
  2. Navigate to HKLMSOFTWAREMicrosoftUpdates
  3. In the right navigation pane, double-click the UpdateExeVolatile key.
  4. Configure the key with a value of 0
  5. Close Registry Editor.

To delete the orphaned PendingFileRenameOperations registry key

  1. Open a registry editor, such as Regedit.exe or Regedt32.exe.
  2. Navigate to HKLMSYSTEMCurrentControlSetControlSession Manager
  3. In the right navigation pane, right-click the PendingFileRenameOperations key and select Delete.
  4. Close Registry Editor.

ISSUE #4:  when running the SharePoint 2010 Products Configuration Wizard you may experience the error:

Failed to register SharePoint services.
An exception of type System.ServiceProcess.TimeoutException was thrown.  Additional exception information: Time out has expired and the operation has not been completed.
System.ServiceProcess.TimeoutException: Time out has expired and the operation has not been completed.
   at System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus desiredStatus, TimeSpan timeout)

Run Setup.exe when the steps above have been completed.

To resolve the issue you can perform the following steps:

Download and install KB976462 from http://support.microsoft.com/kb/976462 for Windows Server 2008 R2 or KB971831 from http://code.msdn.microsoft.com/Project/Download/FileDownload.aspx?ProjectName=KB971831&DownloadId=7285 for Windows Server 2008 and run the SharePoint 2010 Products Configuration Wizard.

ISSUE #5:  when running the SharePoint 2010 Products Configuration Wizard you may experience the error:

Error: Cannot add the specified assembly to the global assembly cache: C:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions14policyPolicy.11.0.Microsoft.SharePoint.dll.

To resolve this issue you can perform the following steps:

Delete the contents of %commonprogramfiles%Microsoft SharedWeb Server Extensions14policy and run the SharePoint 2010 Products Configuration Wizard.

ISSUE #6:  when running Setup.exe for Microsoft SharePoint Server 2010 you may experience the following error:

The language of this installation is not supported by your system

This issue is largely caused by corruption of the binaries, you can use the extract command in a Command Prompt and check the log to determine the health of the binaries; otherwise, download a new copy of the binaries and retry setup.