SharePoint: WSS 3.0 Database Location in SBS 2008

Default SharePoint Services (WSS) 3.0 Database Location

Windows Small Business Server 2008 stores the SharePoint Services 3.0 databases by default in:
C:\Windows\SYSMSI\SSEE\MSSQL.2005\MSSQL\DATA\

The database for CompanyWeb is: ShareWebDb.mdf

Databases that the Windows SharePoint Services engine uses.
SharePoint_AdminContent_{GUID}, SharePoint_Config_{GUID}, WSS_Content, and WSS_Search_Win****.   
Additional Databases in folder.

System Databases and SUSDB.  

Locate the database files:

If you are supporting a system and want to determine the actual location of the WSS database files.

Connect to Microsoft SQL Server:

1. Logon to server with account that has access to database.
   On most Small Business Server systems this will be the default domain admin account. I tend to use a separate account for SQL administration.

2. Start, All Programs, Microsoft SQL Server 2005,

1. right-click Microsoft SQL Management Studio Express

2. click Run as Administrator.

3. On the User Account Control page, click Continue.

4. In the Connect to Server dialog box, do the following:

   1. Server type: Database Engine.
   2. Server name: np:\\.\pipe\MSSQL$Microsoft##SSEE\sql\query
   3. Authentication: Windows Authentication.

5. click Connect

6. click New Query and copy the following into the query. 
   
   select a.name, b.name as 'Logical filename', b.filename from sys.sysdatabases a
   inner join sys.sysaltfiles b
   on a.dbid = b.dbid where fileid = 1
   

7. click Execute.

8. Location of the database files are displayed, lookup ShareWebDb in the table.

Further Information:

I based this blog entry around the following TechNet article. however, the query for locating the database did not work and I found the alternative included in this entry.

Microsoft TechNet: Repair Windows SharePoint Services after moving the databases