microsoft.public.sqlserver.server

Author

Data Redundancy

Bruce de Freitas

2002-12-10, 10:24 am

You can do replication... or Log Shipping to "copy"
database info to another location if that's what you
mean?!?... Those are built-in features o f SQl Server.
Other mthods exist that use SQL Server tools, like DTS
packages... Bruce

>-----Original Message-----
>DOes SQL server 2000 have the ability to support data
Redundancy?
>
>
>.
>

Duane Foote

2002-12-10, 2:23 pm

1. So I can set up two machines and have database replication from one PC to
another..?
2. What is the difference between Publisher and Distributor?

"Bruce de Freitas" <bruce@defreitas.com> wrote in message
news:04a801c2a061$019662e0$8df
82ecf@TK2MSFTNGXA02...
> You can do replication... or Log Shipping to "copy"
> database info to another location if that's what you
> mean?!?... Those are built-in features o f SQl Server.
> Other mthods exist that use SQL Server tools, like DTS
> packages... Bruce
>
>
> >-----Original Message-----
> >DOes SQL server 2000 have the ability to support data
> Redundancy?
> >
> >
> >.
> >

Sponsored Links