Monthly Archives: August 2011

Home » Archives for August 2011

Restoring Large SQL Databases

When attempting to restore a large database using SQL Server 2008 Management Studio, the following error may be thrown: An exception occurred while executing a Transact-SQL statement or batch Timeout expired Microsoft Knowledge Base article 967205 discusses the problem, although the article is referring to problems restoring from tape. The article suggests that this problem [...]

By |2016-12-07T16:29:25+04:30August 27th, 2011|SQL|Comments Off on Restoring Large SQL Databases

Change “Overwrite Existing Files” Behavior

In SharePoint, when a user chooses to upload a single document or multiple documents into a document library that does not have versioning enabled, the check box for "Overwrite existing files" is automatically checked. If the document library has versioning enabled, the option changes to "Add as a new version to existing files" and is [...]

By |2016-12-08T13:52:31+04:30August 25th, 2011|Tips|4 Comments

Server 2008 and NLB Event 105

When running SharePoint on Server 2008 and using a Network Load Balancing (NLB) cluster, the following warning messages may sporadically appear in the System event log: SOURCE: NLB Event ID: 105 NLB cluster []: Timer starvation has been detected. This might be due to a denial of service attack or a very high server load. [...]

By |2016-12-08T13:51:39+04:30August 25th, 2011|Tips|4 Comments

Removing Orphaned Application Pool Objects From Central Administration

When working with Central Administration and Service Accounts, you may find application pools listed that no longer exist on the portal. More than likely this was caused by application pools being changed or deleted directly through IIS. Although IIS knows the application pools are gone, SharePoint has no idea. Fortunately, PowerShell can help with this. [...]

By |2016-12-08T12:31:19+04:30August 20th, 2011|PowerShell|Comments Off on Removing Orphaned Application Pool Objects From Central Administration

Visual Upgrade/Downgrade of SharePoint 2010 Site

While you can perform a Visual Upgrade on a SharePoint 2007 site after importing it into SharePoint 2010, what if you want to change it back? The SharePoint 2007/2010 visual style is determined by the site's UIVersion property. A value of 3 dictates a 2007 look and feel, while a value of 4 dictates a [...]

By |2016-12-08T13:38:15+04:30August 15th, 2011|PowerShell|Comments Off on Visual Upgrade/Downgrade of SharePoint 2010 Site

Service Timer Locks

Windows does not like inaccurate time. When the system time between a domain controller and a remote machine is more than 5 minutes apart, the remote machine will not be able to authenticate, and the user at the remote machine will not be able to log on. Not the start to a great day. Windows [...]

By |2016-12-08T13:49:20+04:30August 13th, 2011|Tips|Comments Off on Service Timer Locks

Change Database Owner

I received the following fun message while attempting to change SQL Server 2008 database properties: Cannot show requested dialog (sqlMgmt) Property Owner is not available for database xyz.  This property may not exist for this object, or may not be retrievable due to insufficient access rights. Visiting Uncle Google came up with some information regarding [...]

By |2016-12-08T13:40:29+04:30August 4th, 2011|SQL|Comments Off on Change Database Owner

Delete Site Collection AFTER Deleting Database

Here's a fun one.  A site collection was created on a development portal to test database restores.  When the database backup was restored to the portal, SharePoint lost all access to the site collection.  The site collection was still listed, but no information returned about the database, and of course no access to the portal URL.  As [...]

By |2016-12-08T13:41:51+04:30August 3rd, 2011|SQL|Comments Off on Delete Site Collection AFTER Deleting Database
Go to Top