Discover core databases for a Windows SharePoint Services 3.0 farm

Posted on March 4, 2010, under SharePoint.

Below are steps for one method to discover databases used by a WSS 3.0 farm. Log in to SharePoint Central Administration for each of these activities.

Configuration Database

  1. Go to the “Operations” tab
  2. Click “Servers in Farm”
  3. Under “Farm Information” see the following items:
    1. Configuration database server
    2. Configuration database name

Central Administration Content Database

  1. Go to the “Application Management” tab
  2. Click “Web application list”
  3. Click “SharePoint Central Administration v3″
  4. Under “SharePoint Site Management”, click “Site collection list”
  5. Under the root “/” site, look in the information table for the “Database Name” value

General Usage Content Databases

  1. Go to the “Application Management” tab
  2. Click “Web application list”
  3. For each web application listed other than “SharePoint Central Administration v3″ (see above), perform the following:
    1. Click the web application name
    2. Under “SharePoint Site Management”, click “Site collection list”
    3. For each listed site collection (by URL):
      1. Click the URL of the site collection
      2. In the information table, look for the “Database Name” value

Search Database

  1. Go to the “Operations” tab
  2. Under “Topology and Services”, click “Services on server”
  3. Click the text “Windows SharePoint Services Help Search”
  4. Under “Search Database”, look for the values:
    • Database Server
    • Database Name

Windows 7 – Homegroups

Posted on October 25, 2009, under Web Dev/Tech.

Finally! Easy home networking. I bought a Windows 7 Home Premium Family Pack (3 licenses), set up a Homegroup to share files and a printer, and I’m loving it. Super easy.

Book Recommendation: MOSS 2007 Best Practices

Posted on December 17, 2008, under SharePoint, Web Dev/Tech.

moss-best-practices-cover

There are several books that stand-out in my career where the value is well over the $50 spent on the book. Microsoft Office SharePoint Server 2007 Best Practices is definitely one of those books.


P.S. Wordpress 2.7 is pretty slick

Microsoft apps on VMware ESX will now be supported

Posted on September 11, 2008, under SharePoint, Web Dev/Tech.

Microsoft will now support their applications running on the VMWare ESX platform running version 3.5 update 2. For anyone using both VMWare and Microsoft technologies (like Exchange, SharePoint, etc), this is great news!