Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2003
    Location
    Cyprus
    Posts
    8

    Unanswered: SQL 2000 transaction Log

    The transaction log file of my SQL 2000 database is too big.How can i clear it in order to start it from zero(0) disk space ?

  2. #2
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    You probably can not start it exactly at 0, if you do not need transacitonal recovery use simple for the recovery mode for the long term. Also, if you do not need transactional recovery, you can run a

    backup log dbname with truncate_only

    then run a shrinkfile on the log.

    If you require transactional recovery, schedule regular backups.

    HTH
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

  3. #3
    Join Date
    Jul 2003
    Location
    Cyprus
    Posts
    8

    SQL Server

    Originally posted by rhigdon
    You probably can not start it exactly at 0, if you do not need transacitonal recovery use simple for the recovery mode for the long term. Also, if you do not need transactional recovery, you can run a

    backup log dbname with truncate_only

    then run a shrinkfile on the log.

    If you require transactional recovery, schedule regular backups.

    HTH

    I only run : backup log dbname with truncate_only - but still my transaction log has the same disk space 470.144 KB . So is there a way to make this file smaller ?
    Because i'm realy trying to learn more about SQL Server and i just start lerning i didn't understand and i must do hwen you said- "then run a shrinkfile on the log" so i believe is better to explain to me in a step-by -step process or if you have a checklist it will be better.

    Regards
    Achilleas Achilleos

  4. #4
    Join Date
    Oct 2003
    Posts
    11

    Cool

    Hi,
    There are several ways to shrink your log..
    One is to run: dbcc shrinkfile (filename).
    Another is to run shrink log thru Enterprise manager. Right click your database and choose all task->shrink database->files then choose the file you like to shrink..
    You should also check how much space is allocated for your log.
    Just click properties on your database..

    Hope this helps
    Tommy
    Tsz

Posting Permissions

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