Hello All !
I want to know if there are differences between "Autoshrink" database option and the SQL DBCC shrink (database/file) command.
I have, in production environment, a MS application (MIIS) with a SQL 2005 DB. This application takes very large db files (logs and datas). It's absolutely normal (several millions of transactions by day)
However, I had this morning a problem with disk space.
If I run manual dbcc shrink (db / file): I recover 4 GB
If I set "Autoshrink" option: I recover 50 GB
Microsoft doesn't recommand to set the "autoshrink" option on the majority of databases (for performances problems)
Are there links about these differences ?
Thanks for advance for your ideas / help - Regards - Have a nice day ! RHUM2
View Complete Post