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:
-
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. -
Start, All Programs, Microsoft SQL Server 2005,
-
right-click Microsoft SQL Management Studio Express
-
click Run as Administrator.
-
On the User Account Control page, click Continue.
-
In the Connect to Server dialog box, do the following:
- Server type: Database Engine.
- Server name: np:\\.\pipe\MSSQL$Microsoft##SSEE\sql\query
- Authentication: Windows Authentication.
-
click Connect
-
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 -
click Execute.
-
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
