how can I open MS SQLsharepoint database files

how can I open MS SQLsharepoint database files MSDE 2000 format
I have a copy of the whole SQL folder from c:\program files.

From a SBS 2003 instalation that crashed and oem does not allow me to do a
repair and just would lieke to see what the data contains, even if I can get
to to an excel or Access database to print out would help.

Maybe... (haven't tried it myself)

Using SharePoint Database Explorer on SBS
http://blogs.technet.com/sbs/archive...er-on-sbs.aspx

--
Merv Porter [SBS-MVP]
============================

"Larrycoe" <> wrote in message
news:F772FB62-0405-45AB-8A5D-...
> how can I open MS SQLsharepoint database files MSDE 2000 format
> I have a copy of the whole SQL folder from c:\program files.
>
> From a SBS 2003 instalation that crashed and oem does not allow me to do a
> repair and just would lieke to see what the data contains, even if I can
> get
> to to an excel or Access database to print out would help.
>
>

You can copy the data files (.mdf) and ideally also the log files (.ldf) to
any machine with SQL Server 2000 or later installed, and then attach the
database to SQL Server. There are 2 Sharepoint databases, the configuration
database (STS_Config) and the data database (STS_SBS_1 on my SBS 2003). Once
the database is attached you can use any client software that works with SQL
Server to see the data.

"Larrycoe" <> wrote in message
news:F772FB62-0405-45AB-8A5D-...
> how can I open MS SQLsharepoint database files MSDE 2000 format
> I have a copy of the whole SQL folder from c:\program files.
>
> From a SBS 2003 instalation that crashed and oem does not allow me to do a
> repair and just would lieke to see what the data contains, even if I can
> get
> to to an excel or Access database to print out would help.
>
>