Posted by Erland Sommarskog on 06/26/05 20:19

Paul S Randal [MS] (prandal@online.microsoft.com) writes:
> One small clarification - although everything is logged during a shrink,
> each page is moved inits own transaction internally so if the power cord
> is pulled, only the last page move needs to be rolled-back. All previous
> work is committed and is not lost.

Thanks for the correction, Paul!


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]