Results 1 to 2 of 2

Thread: Log file too big

  1. 01-17-2007, 12:33 PM #1
    pichapie
    pichapie is offline Registered User
    Join Date
    Aug 2006
    Posts
    3

    Log file too big

    We have a sql database with the BAK file at 16GB while the log file is 8GB. Currently setup Recovery = Full. How do we reduce the size of the log file?
    Reply With Quote Reply With Quote
  2. 01-17-2007, 01:06 PM #2
    nosepicker
    nosepicker is offline Registered User
    Join Date
    Dec 2004
    Posts
    502
    When you say "reduce the size", if you mean reduce the number of transactions in the log, then you need to do a log backup (a full backup won't clear out the transactions in the log). But if you want to reduce the actual size of the log file, then you need to backup the log and then do a file shrink (either through Ent. Mgr. or using "dbcc shrinkfile ...").
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules