Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    57

    Unanswered: Database Log file

    Newby question. I've got a very big database log file (not been managed). It won't let me delete it. How do I clear it?

  2. #2
    Join Date
    Feb 2003
    Location
    Brisbane, Australia
    Posts
    110
    Check out this thread:

    http://www.dbforums.com/t1049765.html

    Should have the info you want...

    Basically Backup the DB.. Then shrink your log file..

  3. #3
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    1. backup log with truncate_only
    2. dbcc shrinkfile 'logfile'

    also u can deattach the database - delete the transaction log file - attach back the database.
    Remember, always take a backup before deattaching the database.

    also check this link for more info on transaction log

Posting Permissions

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