Results 1 to 4 of 4

Thread: DBCC SHRINKFILE doesn't shrink the size

  1. Dec 15th, 2008, 04:20 AM #1
    erickwidya
    erickwidya is offline

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2004
    Location
    Jakarta, Indonesia
    Posts
    818

    DBCC SHRINKFILE doesn't shrink the size

    i use DBCC ShrinkFILE(log_file_logical_file_name, TRUNCATEONLY) but it doesn't resize the log size

    it's now "grown up" to 34GB size..

    what should i do?

    thx

    1st NF - a table should not contain repeating groups.
    2nd NF - any fields that do not depend fully on the primary key should be moved to another table.
    3rd NF - there should be no dependency between non key fields in same table.
    - E. Petroutsos -

    eRiCk

    A collection of "Laku-abis" Ebook, Permanent Residence

    Access Reserved Words, a Classic Form Bug, Access Limitation, Know run Process and the Lock they hold in, Logging User Activity in MSSQL,
    Kill Database Processes
    Reply With Quote Reply With Quote
  2. Dec 15th, 2008, 06:25 AM #2
    pvbangera
    pvbangera is offline
    Fanatic Member pvbangera's Avatar
    Join Date
    Sep 2001
    Location
    Mumbai, India
    Posts
    961

    Re: DBCC SHRINKFILE doesn't shrink the size

    TRUNCATEONLY is applicable only to data files and not log files. Fore more info read this
    Microsoft Techie
    Reply With Quote Reply With Quote
  3. Dec 15th, 2008, 06:27 AM #3
    dee-u
    dee-u is offline
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: DBCC SHRINKFILE doesn't shrink the size

    Have a look at this if it helps.
    Regards,

    ™

    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system
    Reply With Quote Reply With Quote
  4. Dec 15th, 2008, 08:29 PM #4
    erickwidya
    erickwidya is offline

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2004
    Location
    Jakarta, Indonesia
    Posts
    818

    Re: DBCC SHRINKFILE doesn't shrink the size

    thx pvbangera, dee-u

    TRUNCATEONLY is applicable only to data files and not log files. Fore more info read this -> from what i read it can truncate log file, maybe i read wrong

    dee-u..it helps

    thx

    1st NF - a table should not contain repeating groups.
    2nd NF - any fields that do not depend fully on the primary key should be moved to another table.
    3rd NF - there should be no dependency between non key fields in same table.
    - E. Petroutsos -

    eRiCk

    A collection of "Laku-abis" Ebook, Permanent Residence

    Access Reserved Words, a Classic Form Bug, Access Limitation, Know run Process and the Lock they hold in, Logging User Activity in MSSQL,
    Kill Database Processes
    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


Click Here to Expand Forum to Full Width