We run an SBS 2008 server with WSS. On the drive I have set aside for WSS, I'm fast running out of space due to the ShareWebDb_log.ldf file being >96GB!
File size is huge compared to the actual sharepoint site (15 GB)
I've tried doing to do what I've read online - change the recovery mode, backup and truncate - but I can't actually see how I do this via the SQL Server Management Studio tool. Can anyone shed any light?
ShareWebDb_log.ldf is not listed in the databases tree node so I can see no way to do this.