SQL Server Performance Forum – Threads Archive
Can .ldf file be deleted or clearedI have question ?? My database .ldf file has gone to 800 MB which i want to either
delete 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
attache mdf again for safety reasons take a backup of you database before dettching —————————————-
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
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.