Best way to shrink SQL 2000 .LDF file
Posted on 2011-09-08
I am searching on the best way to shrink this LDF file in my Attendance database. I have found various ways and tried a few that didnt work. Here are the details....
Attendance.mdf --> 1.4GB
Attendnace_log.LDF --> 30.4GB
I am a "Beginner" at SQL so i know very little. I have seen a few options i was wondering about.
* SQL Server Enterprise Manager --> Databases --> right click attendance and go to propertiers. Then on the Transaction Log tab there is a checkbox for "Automatically grow file". This is checked and along with "File Growth by percent 10" and then also Maximum file size is set to Unrestricted file growth. Should i change this and if so to what?
* Other option i have been seeing is the same properties box but on the Options tab there is a "Recovery Model" that is set to Full. Should i change this to simple? I have read this will shrink it also.
I would just like to get the log file down to the same as the MDF file or pretty close anyways if at all possible. Thanks for any help on this.