August 6, 2008 at 1:18 am
i want to restricting file growth of sql server as it was crossed limit which is 10.0MB it is now 18.3MB due to file growth of the ldf file and mdf file plz help me in reducing the size of the both files particularly ldf file
regards
Thomas Vinod
(9441288504)
August 6, 2008 at 2:19 am
The size of your LDF file depends on the recovery model of the database. If it set to "Simple" the LDF file won't grow a lot, beacuse the space in the file becomes unused as soon as the transactions end. If the recovery model is "Full" the LDF file will grow until a backup is performed.
If you don't need a Full recovery, set your db to Simple and shrink the LDF file when it becomes too large. Note that if the LDF file grows to a certain size even in simple recovery or with regular backups, that means that the production size of the file is around that size: any effort to keep the LDF file under that size will be useless, or, at least, hurt performance.
Regards
Gianluca
-- Gianluca Sartori
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply