Layzell avatar image
Layzell asked

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
1 comment
10 |1200

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

KenJ avatar image KenJ commented ·
It looks like you got this answered over at I've seen the same space doubling that was discussed there.
0 Likes 0 ·

0 Answers