01 Oktober 2009 21:05Running SBS 2008. The log file named ShareWebDb_log.ldf is 46gb in size. The ShareWebDb_log.mdf file is only 17gb in size. Is there a way for me to reduce the size of the ShareWebDb_log.ldf file?
09 Oktober 2009 19:42I have the same issue with a SBS 2008 over here.
10 Oktober 2009 14:37Not sure if this is the best approach but here is what I did to reduce the file size:
1 - Start SQL Management Studio and connect to the server: \\.\pipe\mssql$microsoft##ssee\sql\query
2 - Backup the database
3 - Open the properties window of the database
4 - Select Options
5 - Changed the recovery model to simple
6 - Tasks -> Shrink -> Shrink Files
7 - Change the File Type to log and then activate the "OK" button.
Here is more information on Full vs Simple recovery model: