Database Shrink

• SqlSavy

  SSCarpal Tunnel

  Points: 4065

  More actions

  October 16, 2012 at 3:31 am

  #263298

  We've recently archived a massive database and we want to shrink it to recover disk space.

  I know shrinking is not a good practice but as archiving is done I want to shrink it.

  I am planning to run DBCC SHRINKDATABASE I’ve already implemented this on CTC a while back without any issues.

  But if Shrink activity is stopped before it completes what is the impact on the database?

  Thansk in advance

• Eugene Elutin

  SSC Guru

  Points: 59322

  More actions

  October 16, 2012 at 4:36 am

  #1549443

  The answer is in here:

  http://msdn.microsoft.com/en-us/library/ms190488.aspx

  DBCC SHRINKDATABASE operations can be stopped at any point in the process, and any completed work is retained.

  _____________________________________________
  "The only true wisdom is in knowing you know nothing"
  "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
  (So many miracle inventions provided by MS to us...)

  How to post your question to get the best and quick help[/url]

• SqlSavy

  SSCarpal Tunnel

  Points: 4065

  More actions

  October 16, 2012 at 4:43 am

  #1549447

  Thanks