edwalt's - Things I Wish I'd known about SBS 2003....
SharePoint Database Explorer
This tool will help you export files from a corrupt .mdf database. In order for this to work you must be able to successfully mount the database either through OSQL or SQL. This tool should be used at your own risk. Thanks
Program Download location: http://mindsharpblogs.com/james/archive/2005/01/20/189.aspx
Database Files needed:
2. STS_Servername _1_log.ldf.
Using SharePoint Database Explorer with OSQL
osql -S servername\sharepoint –E1>EXEC sp_attach_db @dbname = 'STS_SERVERNAME_1', @filename1 = 'C:\Program Files\Microsoft SQL Server\MSSQL$SHAREPOINT\Data\ STS_SERVERNAME_1.mdf', @filename2 = 'C:\Microsoft SQL Server\MSSQL$SHAREPOINT\Data\STS_SERVERNAME_1_log.LDF'
Using SharePoint Database Explorer with SQL Server
The database should now be attached.
Open SharePoint Database Explorer
qWPyUC r u crazzy? I told u! I can't read!
XK9JDL r u crazzy? I told u! I can't read!
dRMZGB r u crazzy? I told u! I can't read, man!
RrpfwO r u crazzy? I told u! I can't read!
xcSQv1 r u crazzy? I told u! I can't read!
3WNNkt r u crazzy? I told u! I can't read!
oCQgsT r u crazzy? I told u! I can't read!
YAE3hP r u crazzy? I told u! I can't read!
iMehBX r u crazzy? I told u! I can't read!
ptjlm5 r u crazzy? I told u! I can't read!
I am trying to access data via SQL server. The databses have been attached, but do not show up in the select drop down list in DBExplore, just a number of listings for "master" which fail to connect. What do I need to do to access the attached DBs in SQL? Thanks
I noticed that if you have subfolders and a list and multiple files with the same name in different subfolders within the list, then the software only lists one file with that name and you do not knwo which subfolder it belows to.