Results 1 to 3 of 3

Thread: LDF Files

  1. #1
    Join Date
    Nov 2004
    Posts
    285
    Provided Answers: 1

    Unanswered: LDF Files

    Good day,

    I have an instance where LDF files for what ever reason hadn't been added to the maintenance plan to be backed up. The LDF file has now grown to over 500GB and I only have a 650GB hard drive. If I set the recovery model to Simple and Shrink the LOG file will I loose any data? I know it will shrink the size but what about any loss of data, that is what I am worried about? There is enough space to do a FULL database backup first.

    Please can someone advise.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    The LDF file is the transaction log. If you set the database to simple recovery mode, and shrink the file, you will not lose any business data. You will, however, lose the ability to perform restores of data to a point in time after the last FULL backup. If you have space for it, you can back up the transaction log, then shrink the file. This will lose no business data or recovery data at all.

  3. #3
    Join Date
    Apr 2011
    Location
    Pakistan
    Posts
    28
    If you have available space on the other server then you can take the network log or full backup and shrink these log files

    execute CHECKPOINT statement,there is no loss of Data

    Regards,

    Syed Jahanzaib Bin Hassan
    MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    A|U|R|E|U|S – S|A|L|A|H

Posting Permissions

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