Prev: Crf50 Performance Part
Next: "Transaction Log Shipping Status" not updating
From: John on 20 May 2010 19:40
We have 2 SQL 2005 servers. One in the local office and a Second at a co-lo
in another state.
What I am needing to do, to replicate the local one, to the co-lo. I am
thinking that Transactional would be best as it would keep an almost realtime
copy.

The part I am not sure about, is if we add a table, or modify a table, will
that change get replicated out as well?
From: Ben Thul on 20 May 2010 23:03
Before you embark down the replication path, what need are you trying
to serve? Replication may or may not be the right answer depending.
It sounds like your need may be to have a backup copy at your co-lo,
in which case log shipping or mirroring might serve you better.

But, to answer your question, some schema changes are handled
automatically while others aren't. For instance, adding a new table
to the published database isn't handled automatically, but changes to
already replicated tables are (assuming you've configured it for
this).

On May 20, 7:40 pm, John <J...(a)discussions.microsoft.com> wrote:
> We have 2 SQL 2005 servers.   One in the local office and a Second at a co-lo
> in another state.
> What I am needing to do, to replicate the local one, to the co-lo.   I am
> thinking that Transactional would be best as it would keep an almost realtime
> copy.
>
> The part I am not sure about, is if we add a table, or modify a table, will
> that change get replicated out as well?

From: John on 21 May 2010 10:53
it is so that we would have a backup copy. I havent heard of 'log shipping'
before, but wouldn't mirroring take a lot of bandwidth?

"Ben Thul" wrote:

> Before you embark down the replication path, what need are you trying
> to serve? Replication may or may not be the right answer depending.
> It sounds like your need may be to have a backup copy at your co-lo,
> in which case log shipping or mirroring might serve you better.
>
> But, to answer your question, some schema changes are handled
> automatically while others aren't. For instance, adding a new table
> to the published database isn't handled automatically, but changes to
> already replicated tables are (assuming you've configured it for
> this).
>
> On May 20, 7:40 pm, John <J...(a)discussions.microsoft.com> wrote:
> > We have 2 SQL 2005 servers. One in the local office and a Second at a co-lo
> > in another state.
> > What I am needing to do, to replicate the local one, to the co-lo. I am
> > thinking that Transactional would be best as it would keep an almost realtime
> > copy.
> >
> > The part I am not sure about, is if we add a table, or modify a table, will
> > that change get replicated out as well?
>
> .
>
From: Ben Thul on 21 May 2010 12:26
Ah... so you are trying to accomplish some sort of high availability.
In that case, I'd definitely suggest either mirroring or log-
shipping. I'll answer your question about bandwidth with another
question: how much is your data (and uptime) worth?

Relevant BOL links:

Log shipping: http://msdn.microsoft.com/en-us/library/ms187103%28SQL.90%29.aspx
Mirroring: http://msdn.microsoft.com/en-us/library/ms177412(SQL.90).aspx
High availability: http://msdn.microsoft.com/en-us/library/ms190202%28SQL.90%29.aspx

HTH!

On May 21, 9:53 am, John <J...(a)discussions.microsoft.com> wrote:
> it is so that we would have a backup copy.   I havent heard of 'log shipping'
> before, but wouldn't mirroring take a lot of bandwidth?
>
> "Ben Thul" wrote:
> > Before you embark down the replication path, what need are you trying
> > to serve?  Replication may or may not be the right answer depending.
> > It sounds like your need may be to have a backup copy at your co-lo,
> > in which case log shipping or mirroring might serve you better.
>
> > But, to answer your question, some schema changes are handled
> > automatically while others aren't.  For instance, adding a new table
> > to the published database isn't handled automatically, but changes to
> > already replicated tables are (assuming you've configured it for
> > this).
>
> > On May 20, 7:40 pm, John <J...(a)discussions.microsoft.com> wrote:
> > > We have 2 SQL 2005 servers.   One in the local office and a Second at a co-lo
> > > in another state.
> > > What I am needing to do, to replicate the local one, to the co-lo.   I am
> > > thinking that Transactional would be best as it would keep an almost realtime
> > > copy.
>
> > > The part I am not sure about, is if we add a table, or modify a table, will
> > > that change get replicated out as well?
>
> > .
>
>

From: John on 21 May 2010 13:56
I am sure that as long as data was restored within an hour, that would be OK.

Would Log-Shipping work if a table was modified by adding a field? or if a
new table was created in a database?



"Ben Thul" wrote:

> Ah... so you are trying to accomplish some sort of high availability.
> In that case, I'd definitely suggest either mirroring or log-
> shipping. I'll answer your question about bandwidth with another
> question: how much is your data (and uptime) worth?
>
> Relevant BOL links:
>
> Log shipping: http://msdn.microsoft.com/en-us/library/ms187103%28SQL.90%29.aspx
> Mirroring: http://msdn.microsoft.com/en-us/library/ms177412(SQL.90).aspx
> High availability: http://msdn.microsoft.com/en-us/library/ms190202%28SQL.90%29.aspx
>
> HTH!
>
> On May 21, 9:53 am, John <J...(a)discussions.microsoft.com> wrote:
> > it is so that we would have a backup copy. I havent heard of 'log shipping'
> > before, but wouldn't mirroring take a lot of bandwidth?
> >
> > "Ben Thul" wrote:
> > > Before you embark down the replication path, what need are you trying
> > > to serve? Replication may or may not be the right answer depending.
> > > It sounds like your need may be to have a backup copy at your co-lo,
> > > in which case log shipping or mirroring might serve you better.
> >
> > > But, to answer your question, some schema changes are handled
> > > automatically while others aren't. For instance, adding a new table
> > > to the published database isn't handled automatically, but changes to
> > > already replicated tables are (assuming you've configured it for
> > > this).
> >
> > > On May 20, 7:40 pm, John <J...(a)discussions.microsoft.com> wrote:
> > > > We have 2 SQL 2005 servers. One in the local office and a Second at a co-lo
> > > > in another state.
> > > > What I am needing to do, to replicate the local one, to the co-lo. I am
> > > > thinking that Transactional would be best as it would keep an almost realtime
> > > > copy.
> >
> > > > The part I am not sure about, is if we add a table, or modify a table, will
> > > > that change get replicated out as well?
> >
> > > .
> >
> >
>
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: Crf50 Performance Part
Next: "Transaction Log Shipping Status" not updating