• Thanks for the script, but I cannot think of any normal DBA use for it. It is not recommended to shrink all of the databases on a time to time basis. This because of the fragmentation you get on your filesystem. It is recommended to disable the shrink option and size your databases before you place them on the server. Fragmentation will make your server slower.