Home Forums SQL Server 2008 SQL Server 2008 Administration Shrink Data file with truncateonly RE: Shrink Data file with truncateonly

  • February 19, 2013 at 2:36 am

    #1589078

    mwagh (2/19/2013)

    Hi,

    I wanted to shrink a data file with the truncate only clause.Will i require to rebuild my indexes?

    Shrinking data file is not recommended as it will create fragmentation and it affects the performance. What's the reason you are trying to shrink?

    SueTons.

    Regards,
    SQLisAwe5oMe.