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) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply