O'Reilly logo

Microsoft SharePoint 2010 Administration Cookbook by Peter Serzo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Accessing the SharePoint 2010 logging database

As mentioned in the introduction, the SharePoint 2010 logging database is a major enhancement to monitoring, debugging, and protecting the health of the farm.

By default, the database is called WSS_Logging. This database should be the starting point for administrators to collect and analyze information.

In this recipe, we will access the database and run a view (that already is installed) against it.

Getting ready

You must have farm-level administrative permissions to the Central Administration site. You must have read and execute permissions as well to the WSS_Logging database in order to open and execute views.

How to do it...

  1. Open up SQL Server Management Studio.
  2. When asked for authentication, log in ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required