[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

Layzell gravatar 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

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

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: 913 times

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