which are the risks of disable autoshrink on SQL-Server ?
Posted on 2010-09-02
We have an SQL-Server 2000 SP3 in production machine. Sometimes performance slows down and we have seen it's when SQL-server starts an autoshrink process.
We read some articles on internet which says autoshrink slows down the database, so we are thinking about unset this option. The question is: if we uncheck this autoshrink option, could we have problems on backup/restoring database or maybe on our storage system ?
What risks should we consider ?