Truncating Log Files   Truncate the database and shrink the databaseThe following set of SQL will shrink your database and “truncate” the log file. File in the parmaters surrounded by <…>.  Note that you’ll need the two filename values from step 1. USE <yourdatabasename>GOBACKUP LOG <yourdatabasename> WITH TRUNCATE_ONLYGODBCC SHRINKFILE (<yourdatabaselogfilename>, 1)GODBCC SHRINKFILE (<yourdatabasedatafilename>, 1)GOexec sp_helpfile 
Leggi tutto il post...