Hi, I am using Sharepoint Services 3.0 to build a wiki for my company. I know that this seems to be a common issue but I was not able to find a solution on this site or on any others. I cannot shrink the database files for my Sharepoint site in Microsoft SQL Server Management Studio Express. I am using the following steps: Log in to Studio Express, expand out Databases and right click on my Sharepoint_config folder >> Tasks >> Backup and then once the backup has gone ahead, Tasks >> Shrink >> Files at which point, I change the Filetype drop-down choice from Data to Log and hit Ok. Studio Express thinks about this for a second and I get an Executing icon. I have also tried compacting different databases and leaving the Filetype option as Data rather than Log. When I check the size of the Sharepoint_config file in C:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data, it's still at 51.3GB. On one ocassion, it seemed to release about 1GB but it quickly filled it up again. The database file has a dash in it's name so in the command-line option, I placed it in square brackets, but then it had a problem with the inverted commas in the command ...TO DISK=’C:\Sharepoint_config db backup\configLogBackup.bak’ .... I tried all variations on apostrophes, inverted commas etc but it still gives error: Msg 102, Level 15, State 1, I have tried stopping the service in Services.msc so that I can rename the file, but it still says that the file is in use. Currently, out of a total of 60 GB, I have less than 10MB left free. Can you tell me if I need to change my backup setting so that it knows that a full backup has been performed as I have heard that this can cause issues? Many thanks, Justin.

Have you read this article: http://www.techrepublic.com/blog/datacenter/help-my-sql-server-log-file-is-too-big/448

You are using the Windows Internal Database with WSS 3.0. Here are the steps to shrink this DB: http://www.mytechfetish.com/2011/04/how-to-compact-or-shrink-windows.html Thanks & Regards, Kamlesh | Blog | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.

That's perfect, thank you KSDN, worked right away and I have 51.3GB free. Thanks alot!

Thanks alot Howard. KSDN's suggestion worked right away but your link looks like it could also apply to me in the future and I'll add it to my favourites. Thanks alot!