[Closed] 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

more ▼

asked May 08, 2012 at 10:28 PM in Default

avatar image

10 2 2 2

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.

May 09, 2012 at 04:04 AM KenJ
(comments are locked)
10|1200 characters needed characters left

The question has been 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

0 answers: sort voted first

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: May 08, 2012 at 10:28 PM

Seen: 1133 times

Last Updated: May 09, 2012 at 04:04 AM

Copyright 2016 Redgate Software. Privacy Policy