Shrinking an SQL Database

aka_USAPA

What are the ramifications of shrinking an SQL database?

Waldo

Ramifications?

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.

nunomaia

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.

kriki

If it is a test DB, you can do it because, in general, it is better a small DB than a fast DB.

Administrator

[Topic moved from Navision to SQL General forum]