Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    Indonesia
    Posts
    1

    Exclamation Unanswered: How to Maintain TransLog (Detach/attached)

    hi guys, we have a translog database (.LDF) of 60 GB which the contain database itself (.MDF) is only 500 MB. I have detached the translog and succeeded, but when i tried to attached the MDF file, there was an error message says "physical device error D:\\...". Please advice, what should we do towards the .LDF file (60 Gigs) - our objective is to delete/decrease the LDF file mentioned. Thanks in advance.

  2. #2
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    Try this page:

    http://www.support.microsoft.com/?id=272318

    Basically you want to eliminate the data within the log then shrink the footprint of the file. Also, if you do not require transactional recovery you might consider using simple recovery mode which truncates the log upon checkpoint of the data.

    HTH
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •