October 21, 2011 at 12:14 am
Hi Guys
I cannot find a conclusive answer to this
Does changing the recovery model from Full to Bulk_logged really reduce the size of the transaction logs when rebuilding indexes?
October 21, 2011 at 2:24 am
Yes, rebuild index may require less log in bulk logged recovery model: http://msdn.microsoft.com/en-us/library/ms191244.aspx and http://msdn.microsoft.com/en-us/library/ms191484.aspx
October 21, 2011 at 2:27 am
okbangas (10/21/2011)
Yes, rebuild index may require less log in bulk logged recovery model: http://msdn.microsoft.com/en-us/library/ms191244.aspx and http://msdn.microsoft.com/en-us/library/ms191484.aspx
Thanks
October 21, 2011 at 2:27 am
derekr 43208 (10/21/2011)
Hi GuysI cannot find a conclusive answer to this
Does changing the recovery model from Full to Bulk_logged really reduce the size of the transaction logs when rebuilding indexes?
True, It only minimizes the log file size but not log backup size. Even though it depends upon the rebuild mode online/offline.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
October 21, 2011 at 2:31 am
muthukkumaran Kaliyamoorthy (10/21/2011)
derekr 43208 (10/21/2011)
Hi GuysI cannot find a conclusive answer to this
Does changing the recovery model from Full to Bulk_logged really reduce the size of the transaction logs when rebuilding indexes?
True, It only minimizes the log file size but not log backup size. Even though it depends upon the rebuild mode online/offline.
All Indexes are rebuilt online
What do you mean by
It only minimizes the log file size but not log backup size
How does the process work
October 21, 2011 at 2:35 am
Have a look: Link from paul
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
October 21, 2011 at 2:39 am
Thanks
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply