Shrinking an SQL Database

aka_USAPAaka_USAPA Member Posts: 62
edited 2007-03-01 in SQL General
What are the ramifications of shrinking an SQL database?


  • WaldoWaldo Member Posts: 3,412

    There are no consequences as far as I know ... . The only thing I can think of is the fact that the database has to "autogrow" more, and that could have an impact on performance.

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • nunomaianunomaia Member Posts: 1,153
    Every time SQL has to grow performance is decreased during the increase. So shrink SQL when DB log file had increased to an abnormal size.
    Nuno Maia

    Freelance Dynamics AX
    Blog :
  • krikikriki Member, Moderator Posts: 9,079
    If it is a test DB, you can do it because, in general, it is better a small DB than a fast DB.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • AdministratorAdministrator Member, Moderator, Administrator Posts: 2,493
    [Topic moved from Navision to SQL General forum]
Sign In or Register to comment.