locked
Shrink DB RRS feed

  • Question

  • HI Experts, 

    is there any impact if I perform  Shrink Database ?

    Reason that i am Performing shrink DB - To regain unused space. 

    What are the precautionary measures that i need to take before I perform Shrink DB ? I heard it is not advisable to perform Shrink DB 

    What should I do post shrink DB ? 

    Reason to shrink DB- 
    Reason to shrink DB- 
    Reason to shrink DB- 
    Monday, October 10, 2016 5:41 AM

Answers

  • There are some specific reasons behind "Not to Shrink a Database" see here:

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

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


    Monday, October 10, 2016 7:27 AM

All replies