New answers tagged

9

Given my issues, is shrinking so bad? I will rebuild all my indexes. I did a dry run, and brought my database down to 6gb Most of the advice given on the Internet is copied and is disseminated, while not reading the whole topic carefully. There is no doubt that shrinking of data files is bad, but if you ask any SQL guru he would always say, "yes I have ...


6

Looks like you are already aware of the risks associated with shrinking so I wont go over those again. As a once off due to a bug or some form of large growth that will only happen once then doing a one time shrink is fine. Do the shrink, rebuild / reorg the indexes and that should be it. Is your database in SIMPLE or FULL recovery? If Full make sure you ...



Top 50 recent answers are included