What does shrink database do

I doubt any DBA would argue that point. Finite seems to occur between 10 PM — 4 AM. Large databases have a negative downstream impact, too. Size of backups, space needed to restore to lower environments. Brent, As you know there are good reasons e. May wanna step away from the keyboard for a while, get some fresh air. I tell ya this industry is really the pits sometimes, but absolutely you can insult me too, its your webpage.

Then all these concerns about the whitespace left over after an index is defragged are nullified. Have a look at partioning for removing old data perhaps. At the end of the day…. Unless someone has a better idea of course. The caveat being, no perceivable downtime. I suspect I would need to make all the same filegroup changes prior to executing any shrink commands. If shrinking is so bad why Microsoft has included the command?

Kind of stupid in one way or another. Because back in the s, when your SQL Server only had 1GB of space, you actually did need to shrink the files, regardless of performance hits.

Your email address will not be published. Don't subscribe All Replies to my comments Notify me of followup comments via e-mail. You can also subscribe without commenting. Post Comment. Want to advertise here and reach my savvy readers? Last Updated September 15, Brent Ozar. Production Database Administration. Messages FROM sys. INTO dbo. FROM sys. TYPE desc, A.

USE [ database name ]. TYPE desc , A. NAME ;. Heaps, Deletes, and Optimistic Isolation Levels. Leave new Glenn Berry.

Brent Ozar. OK, great! Jeff Mlakar. Oh, you are good. Shand Glenn. Julian Leite. Jean-Luc Lecomte. A very Happy to the team! Daniel Kimberlin. To eliminate the fragmentation, consider rebuilding the indexes on the file after shrinking. Feedback will be sent to Microsoft: By pressing the submit button, your feedback will be used to improve Microsoft products and services.

Privacy policy. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Yes No. Any additional feedback? Skip Submit. Submit and view feedback for This product This page. Note: if Reorganize files before releasing unused space option is checked, it will be possible to choose percent of maximum remaining free space in files after the shrinking process is finished.

Solutions Products Downloads Prices Support. What's new. Database administration Automate critical tasks for database administration Auditing and compliance Database backup Disaster recovery Forensic auditing Index defragmentation Inventory management Load testing Object level restore Server compare SQL job automation SQL Server monitoring Transaction log reading Transactional replication.

Solution center.