sql log size help

[iwltgsfs]

the evvsvaultsore database log file in sql is getting quite large while the database itself is only about 1/8 its size.   Is there a way to srink the transaction log file?  

Scott

[MichelZ]

Hi Scott First of all, make sure that you do full backups of your database, this way, the Transaction Log gets cleared regularly. If you want to shrink it (and you backed it up, that the transaction log has been truncated), then you will be able to do it this way: (asuming sql 2005): In SQL Management Studio: - Right click the Database - Choose "Tasks" - Choose "Shrink" - Choose "Files" Then choose the File Type "Log". You then see "Currently allocated space" and "Available free space". If there is enough available free space, you will be able to shrink the "physical" logfile here. If there is no available space, then you probably haven't backed it up properly lately ;) Cheers Michel

[HiDefGator]

The only way to clear the transaction log is to do a log backup.  The full backup does not truncate the log.   Shrinking the log will not work because it still contains numerous transactions that have not been truncated yet.

[MichelZ]

Yes, of course I mean transaction log backup. Sorry