October 1, 2014 at 12:46 am
Hello,
If I alter column sizes on table in a database whilst in bulk logged mode, will the transaction logs grow like they would in simple or full, or does it qualify as a minimally logged operation?
Thank you,
Regards,
D.
October 1, 2014 at 2:19 am
Operations which can be minimally logged: http://technet.microsoft.com/en-us/library/ms191244%28v=sql.105%29.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 1, 2014 at 1:31 pm
No, changing the column size requires full logging for whatever logging it needs.
But note that increasing a varchar(nnnn) column should only change catalog data, not the data pages, so it should be very quick anyway.
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.
October 1, 2014 at 8:40 pm
Thank you Gail, awesome as usual.
Scott,
Yes, we are doing something similar, we are increasing a column (14,5) to (17,5).
Regards,
D.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply