|
|
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
Navigation:
[Reply to this message]
|