We are running Sharepoint 3.0 along with Sharepoint 2.0 on a SBS2003 Server.The configdatabase log fileforversion 3.0 is > 5 gig. (C:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data\SharePoint_Config_8c34f037-bc86-45b3-8e1f-870dae7010a1_log.LDF) The C partition is filling up fast!!I can access the Sharepoint 2.0 files with the SQL Management Studio but not the SSEE databases.I was able to move the contect database for v2.0 using a document from Microsoft.Info on the web is very confusing and I'm afraid I'm going to break it if I don't do it right, but if I don't do something soon the blob is going to crash the server.

try to shrink the log file. do it this way: run sql query: "select log your_DB_Name with truncate_only" truncate old records in log file ...then try to shrink the file of LOG, not whole database, good luck.allanbeginner

Do I use this cmd to access the db server?sqlcmd -S \\.\pipe\mssql$microsoft##ssee\sql\query -E

I downloaded SQL Server Management Studio Express and I went to connect. C:\Windows\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data\WSS_Content_log.LDF is 80GB+ and I would like to connect to WSS_Content.MDF for my SharePoint 2003 server. I am having trouble logging onto or into the databases. I tried SQL Server Authenitcation with sa (no password) with domain admin password (logged on as admin) and password, and Windows authentication, same error each time. I have tried to log onto the default when it came up: SERVERNAMEHERE\MICROSOFT##SSEE, but that didn't seem to work either. is there a password I can change or any way to get INTO the database at all? "TITLE: Connect to Server ------------------------------ Cannot connect to SERVERNAMEHERE\MICROSOFT##SSEE. ------------------------------ ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ "

strange, as far as i know the default for express (until 2008) is to allow the local admin dba rights. your connection string is obviously wrong, but, as said, it's a pure SQL issue. On a side note, backing up the databases should clear the transaction logs, it is intended to work that way. A database in full mode NEEDS to be backed up regularly (as any DB should ^^) putting the moss databases in simple mode is an alternative for non production environments.