0 like 0 dislike
105 views
asked in MSSQL Database Forum by (13.4k points)  
We have identified that our MSSQL DB has size is more with 93% of available space (as attached). So, as per our understanding DB Shrink can help us in this regard.

 

please let us know the process to get the DB shrink and will there be any impact on application due to shrink ?

Please log in or register to answer this question.

1 Answer

0 like 0 dislike
answered by (13.4k points)  
 
Best answer

Shrinking database data file in production environment is not a good idea. Due to Data file shrink, indexes will be badly fragmented and performance of the database will be degraded. Sometimes index rebuild also may not be helpful. Hence we are not recommending to shrink database data file.

steps to shrink :

  • Take database full backup.
  • Shrink data file (Shrink may happen or may not happen—not sure)
  • Run-rebuild index
  • Run update statistics
  • Validate Database & application performance

Fallback:

Restore Database with last full backup (Step 1)

We would recommend to implement this activity in down time .

Note: We can’t estimate the time to shrink the data file and to run rebuild index over the database.

Related questions

0 like 0 dislike
0 answers
0 like 0 dislike
0 answers
0 like 0 dislike
1 answer
...