SQL Server Performance

Can .ldf file be deleted or cleared

Discussion in 'SQL Server Log Shipping' started by silicon_master, Jul 6, 2006.

  1. silicon_master New Member

    I 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
  2. dineshasanka Moderator

    dettach the database
    delete ldf
    attache mdf again

    for safety reasons take a backup of you database before dettching

  3. Adriaan New Member

    More importantly ...

    Consider the right Recovery Model, in combination with backup strategy. You do have a backup schedule, right?
  4. silicon_master New Member

    Thanks all of u for the suggestion. It's Worth.

    Silicon Master
  5. satya Moderator

    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.
  6. merrillaldrich New Member

    You might consider just shrinking the log file, instead of removing it. That way the DB can remain online.

Share This Page