|
|
Posted by Greg D. Moore \(Strider\) on 05/09/06 15:46
"laststubborn" <arafatsalih@gmail.com> wrote in message
news:1147164897.180455.80350@j33g2000cwa.googlegroups.com...
> Dear All,
>
> We have a big concern in our Database system. We have 2000 transactions
> daily in our database. We need to replicate some how the database for
> our fail over setup. I tried transactional replication at midnight but
> our all systems locked and we had a lot of complaints from the
> customers and It was taking a lot of time to snapshot part and I had to
> abort it because of these reasons.
Why do the transactional replication only at midnight? Better off doing it
continually throughout the day.
And btw, 2000 transactions, unless they're huge, is trivial. I have systems
doing that per minute.
The other option is to look into log shipping.
There are scripts out there that let you do it even w/o Enterprise edition,
though it is then admittedly more manual.
> I need an advice how I can create a replication or is there any other
> way to replicate or is there any way to do this process without
> bothering the system? Please give me some advice and help..
>
> Thanks
> asa.
>
Navigation:
[Reply to this message]
|