How to get started

I am currently running SQL 2000 SP3 as the backend for one of my production
systems. I would like to start doing some kind of repication for quick
diaster recovery efforts. Where would I find instructions for doing this. I
have plenty of hardware available.
Hi
You generally can't implment replication without affecting the application
in some way due to the requiements to have certain types of fileds in place
for replication to work.
Why don't you look at log shipping if you need a DR type scenario?
It is not intrusive at all for the application.
Regards
Mike
"Ronald_L" wrote:

> I am currently running SQL 2000 SP3 as the backend for one of my production
> systems. I would like to start doing some kind of repication for quick
> diaster recovery efforts. Where would I find instructions for doing this. I
> have plenty of hardware available.
|||Thanks Mike, I think that would be best for me as well from what I have been
looking at. How easy is it to put the original primary, back to the primary
once the repair to that device has been completed.
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> You generally can't implment replication without affecting the application
> in some way due to the requiements to have certain types of fileds in place
> for replication to work.
> Why don't you look at log shipping if you need a DR type scenario?
> It is not intrusive at all for the application.
> Regards
> Mike
> "Ronald_L" wrote:
|||I respectfully disagree. Only merge and updateable subscribers require new
"fields"/columns to be added to the underlying tables.
Transactional replication requires a primary key to exist, but does not
require the addition of any columns.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:2870741C-B8B7-4976-9319-5BA193FE796C@.microsoft.com...[vbcol=seagreen]
> Hi
> You generally can't implment replication without affecting the application
> in some way due to the requiements to have certain types of fileds in
> place
> for replication to work.
> Why don't you look at log shipping if you need a DR type scenario?
> It is not intrusive at all for the application.
> Regards
> Mike
> "Ronald_L" wrote: