Wednesday, March 21, 2012

DB shrinking

Hello everyone,
1. What is the downside of having Autoshrink option set to true?
2. If I choose to do it manually, will it affect database performance?
Thanks,
Helenhttp://www.karaszi.com/SQLServer/info_dont_shrink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Helen Stein" <hstein@.nojunklarimor.net> wrote in message
news:upvyS%23D7EHA.3368@.TK2MSFTNGP10.phx.gbl...
> Hello everyone,
> 1. What is the downside of having Autoshrink option set to true?
> 2. If I choose to do it manually, will it affect database performance?
> Thanks,
> Helen
>

No comments:

Post a Comment