Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2006
    Posts
    5

    Exclamation Unanswered: Log file Shrinking

    how can we shrink the log file to the required size without affecting the live database .....

    Thanks in advance

  2. #2
    Join Date
    Nov 2006
    Location
    UK
    Posts
    46
    I hope it can help you:

    --Truncating the transaction log
    BACKUP LOG { database_name | @database_name_var }
    {
    WITH
    { NO_LOG | TRUNCATE_ONLY } ]
    }

    NO_LOG | TRUNCATE_ONLY
    Removes the inactive part of the log without making a backup copy of it and truncates the log by discarding all but the active log. This option frees space. Specifying a backup device is unnecessary because the log backup is not saved. NO_LOG and TRUNCATE_ONLY are synonyms.


    Regards
    Kris Zywczyk

  3. #3
    Join Date
    Nov 2006
    Posts
    5

    Thumbs up Thanks

    It is working.Thanks for this

Posting Permissions

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