|
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
(comments are locked)
|
The question has been closed May 09 '12 at 01:17 PM by Fatherjack for the following reason:
Same question posed on SQLServerCentral forums got clear and accurate answer
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.