2 ms sql server backup

[Jason]

Hi,

I have 2 MS SQL Server 2000. What I want to do is when Server 1 has
database changed, then all the data changed will be reflected to Server 2.
What will I have to do in these 2 servers?
Any help will be appreciated.

Jason

[Greg D. Moore \(Strider\)]

Re: 2 ms sql server backup


"Jason" <Jason@etc.org. tw> wrote in message
news:cp0i4c$m0g $1@news.seed.ne t.tw...[color=blue]
> Hi,
>
> I have 2 MS SQL Server 2000. What I want to do is when Server 1 has
> database changed, then all the data changed will be reflected to Server 2.
> What will I have to do in these 2 servers?[/color]

Google on log shipping and/or replication. (note each has its use, they are
not the same thing nor can they be used to provide the same results.)

[color=blue]
> Any help will be appreciated.
>
> Jason
>
>[/color]

[Jason]

Re: 2 ms sql server backup

Thanks Greg!

"Greg D. Moore (Strider)" <mooregr_delete th1s@greenms.co m> ¦b¶l¥ó
news:9eQsd.3757 4$1u.20812@twis ter.nyroc.rr.co m ¤¤¼¶¼g...[color=blue]
>
> "Jason" <Jason@etc.org. tw> wrote in message
> news:cp0i4c$m0g $1@news.seed.ne t.tw...[color=green]
> > Hi,
> >
> > I have 2 MS SQL Server 2000. What I want to do is when Server 1 has
> > database changed, then all the data changed will be reflected to Server[/color][/color]
2.[color=blue][color=green]
> > What will I have to do in these 2 servers?[/color]
>
> Google on log shipping and/or replication. (note each has its use, they[/color]
are[color=blue]
> not the same thing nor can they be used to provide the same results.)
>
>[color=green]
> > Any help will be appreciated.
> >
> > Jason
> >
> >[/color]
>
>[/color]