Post reply

Database Shrink

  • 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

  • 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]

  • October 16, 2012 at 4:43 am

    #1549447

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply