Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2003
    Posts
    12

    Unanswered: cleaning out my transaction db (*.ldf)

    i have an sql db which is about 400 megs the transaction log is over 2 gig. how can i bring the size down. does enterprise manager have some sort of shrink, compress or delete tool that i can use.

    thank you,
    Thomas

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: cleaning out my transaction db (*.ldf)

    Try DBCC Shrinkfile.

  3. #3
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Read up dbcc shrinkfile from the Holy book (SQL Server Books Online)

    Also here is a reference :
    http://www.dbforums.com/showthread.php?threadid=861115
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  4. #4
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    You need to back it up! After is has been backed up once or twice then you can use DBCC SHRINKFILE to reduce its size.
    Regards
    Dbabren

  5. #5
    Join Date
    Feb 2002
    Posts
    2,232
    If you still have a problem shrinking the log, please post back.

Posting Permissions

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