This question was closed May 09, 2012 at 01:17 PM by Fatherjack for the following reason: Same question posed on SQLServerCentral forums got clear and accurate answer

question

Layzell asked May 8, '12

Changing a Text datatype to XML, what are the impacts on log shipping

Hi everyone, I am due to make a change to our 2005 Production DB. This change involves updating a Text field to XML. The questions are: • what impact will this have on both databases regarding size/growth and how would I measure and manage this • what is the impact to any log shipping to our disaster recovery database as I expect it to grow substantially? Many thanks, Phil

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ commented · May 09, 2012 at 04:04 AM

It looks like you got this answered over at http://www.sqlservercentral.com/Forums/Topic1296801-146-1.aspx I've seen the same space doubling that was discussed there.

0 ·