SQL Server Performance Forum – Threads Archive
Can .ldf file be deleted or cleared
I have question ?? My database .ldf file has gone to 800 MB which i want to eitherdelete and manipulate or to empty/clear so that it doesn’t takes that much space. How should i go about it. Silicon Master
dettach the database
delete ldf
attache mdf again for safety reasons take a backup of you database before dettching —————————————-
http://dineshasanka.blogspot.com/
More importantly … Consider the right Recovery Model, in combination with backup strategy. You do have a backup schedule, right?
Thanks all of u for the suggestion. It’s Worth. Silicon Master
800 MB is not a big size to worry and if you don’t have any disk space issues then consider what Adrian referred to maintain a schedule of events. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
You might consider just shrinking the log file, instead of removing it. That way the DB can remain online.
]]>