Home Forums SQL Server 2005 Administering DBCC SHRINKFILE is not working as expected ?? RE: DBCC SHRINKFILE is not working as expected ??

  • May 30, 2008 at 4:14 am

    #822192

    This is what BOL has to say regarding TruncateOnly:

    TRUNCATEONLY

    Releases all free space at the end of the file to the operating system but does not perform any page movement inside the file. The data file is shrunk only to the last allocated extent.

    target_size is ignored if specified with TRUNCATEONLY.

    TRUNCATEONLY is applicable only to data files.

    Given the current conversation, I thought you might find it interesting.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.