Shrink all database

Rédigé par M Sozezzo - - Aucun commentaire

This script backup and shrink all database.

Everybody says to never use it but shrinking is necessary if your log/data has grown out of control, or as part of a process to remove excessive fragmentation.

 

Source:
http://www.sqlskills.com/blogs/paul/why-you-should-not-shrink-your-data-files/

https://www.brentozar.com/archive/2009/08/stop-shrinking-your-database-files-seriously-now/

 

Lire la suite de Shrink all database

Fil RSS des articles de ce mot clé