Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2004
    Posts
    2

    Unanswered: 'Truncate' command doesn't truncate enough

    With a database size of almost 2 GB, I run the 'truncate table eventlog command' which completes successfully, but the database size only decreases by about 10 MB so stays too large - indeed the number of rows in the eventlog table is minimal, but the otehr tables in this database don't show such an amount of tables large enough to cause the size issue either. What could be the reason and how can I reduce it (possibly truncating another table but then which one, how could I determine which is too large and needs truncating?).
    Last edited by JanW; 12-30-04 at 04:59. Reason: Update

  2. #2
    Join Date
    Dec 2004
    Location
    Kharkov, Ukraine
    Posts
    40
    Truncate table removes all rows from a table.
    Execute "shrink database" for decrease size of database files .
    Enterprise Manager\Action\All Tasks\Shrink Database

  3. #3
    Join Date
    Dec 2004
    Posts
    2
    Thank you for your reply! If however that isn't an option via the menu, can that comand also be executed as a query and if so, could you please indicate what the format/command line should be?

  4. #4
    Join Date
    Feb 2004
    Posts
    492
    dbcc shrinkdatabase (dbname...)

Posting Permissions

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