Results 1 to 2 of 2

Thread: About SQL Server

  1. #1

    Thread Starter
    Fanatic Member Wen Lie's Avatar
    Join Date
    Jul 1999
    Location
    Singapore
    Posts
    524

    Post

    Dear All...

    I've one problem...

    I have a database at SQL Server... And as we know, that every transaction to the database will recorded into log file...

    My question is..
    if the log file is already too large... how can I delete it ?? I mean.. how can I make it small again...???

    Thx...a lot...

    Wille
    Junior VB Programmer

  2. #2
    New Member
    Join Date
    Nov 1999
    Posts
    4

    Post

    If you have a database administrator, discuss the problem with her. If not, read up on backup strategies and log maintenance. There are a few options including various TRUNCATE LOG options for the log, but it also depends on your database backup strategy.

    If the Truncate Log On Checkpoint flag is set for your database, only uncommitted transactions take up space in the log.

    HTH,
    Tore.

Posting Permissions

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



Click Here to Expand Forum to Full Width