Bill Baer (ˈbɛər)
Bill Baer is a Senior Product Manager and Microsoft Certified Master for Microsoft Search, Assistant, and Intelligence at Microsoft in Redmond, Washington.
Intermittent Database Server Connectivity and Microsoft SharePoint Products and Technologies
Intermittent connectivity to a database server hosting Microsoft SharePoint Products and Technologies databases can occur for a number of reasons. In some cases it may be related to a simple database connection timeout configuration setting in Windows SharePoint Services or in other cases it may be one or more operating system and/or hardware configurations. In this post we’ll examine several options and configuration settings that can be adjusted to help isolate or mitigate such occurrences.
Renaming Content Databases
I received an inquiry this morning on what procedural steps are required to rename a Windows SharePoint Services 3.0 content database and decided to make the information more broadly available. Step 1 Detach Content Database Detach the Windows SharePoint Services 3.0 content database from its associated Web application in either Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server 2007 using the steps as outlined below: On a Web front-end computer open a command prompt and change directories to %commonprogramfiles%Microsoft SharedWeb Server Extensions12BIN.
Tip of the Day, April 25, 2008
Tip of the day: Deleting orphaned Timer Jobs Open SharePoint Central 3.0 Central Administration and click Operations. Select Timer job definitions under Global Configuration.
Select the orphaned Timer Job from the list of Timer Jobs. Locate the Globally Unique Identifier (GUID) for the Timer Job in the browser address bar.
Copy the GUID to the clipboard and replace %2D in the GUID with hyphens. For example the entry in the illustration above should appear as fc42d1d3-1e94-4dee-998d-e0086b6f8300.