Can't Connect to SharePoint Instance in SBS 2008

We just noticed that the SharePointConfig log file on our SBS2008 server is over 400 GB and growing very quickly (80 GB over the last 3 days).  The database is under 20 GB.  I have searched the internet for solutions and all require connecting to the SQL instance through the SQL Server Management studio.

Unfortunately, I cannot seem to find the database in the Management Studio interface.  I can browse to the mdb file and log file with Windows Explorer.  Is there a trick to connecting?

I know that SharePoint is integral to SBS, so am reluctant to disable.  Is there a way to at least stop the logging process?

Short of that, will temporarily disabling SharePoint affect anything other than Remote Web Workplace?  We have a new server on order that will not use SBS, so I just need a solution to get us through the next two weeks.  At the rate the log is growing, we will be out of space in a couple of days.

Any feedback would be greatly appreciated.
LVL 2
jspazianoctoAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Randy DownsOWNERCommented:
Try this to stop logging.

WSS V3 out of the box has extensive logging activity, Logs can be usually found in this directory and tend to grow significantly over time:   C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\LOGS
If you are running WSS V3 in a developement environement or in a VPC and want to optimize resources, you can disable logging activity by doing the following:
Go to WSS V3 Central Administration -> Operations -> Logging and Reporting
Click on Diagnostic Logging
Customer Experience Improvement Program: select No, I don't wish to participate
Error Reports: select Ignore errors and don't collect information.
Trace log: clear the entire Path.
Click OK
Click on Usage Analysis Processing
Uncheck Enable logging
Click OK
Click on Information Management Policy Usage Reports
Uncheck Enable recurring policy usage reports
Please remember that once you have disabled logging it will be impossible to troubleshoot any PS nor WSS errors. This is not a recommended setting for any production system!

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.