MSSQL - 11th May 2007 1:12pm
I have a database that was setup far before my time in my current employment. The log file has grown to 40GB, i have set limits on it to stop it growing any more. I really need to shrink this log file quite consideribly. The database has a full backup every week and an incremental backup every night.
My knowledge of MS SQL server isn't amazing, but i was under the impression this might purge the logfiles like it does with MS Exchange when that is backed up.
The database is only about 300mb and is currently only used for reference. Should i delete the log file and start again with restricted log file sizes?
My knowledge of MS SQL server isn't amazing, but i was under the impression this might purge the logfiles like it does with MS Exchange when that is backed up.
The database is only about 300mb and is currently only used for reference. Should i delete the log file and start again with restricted log file sizes?