|
|
Posted by laststubborn on 05/09/06 17:40
Greg D. Moore (Strider) wrote:
> "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.
The thing is snapshot taking a lot of time to do it. Even at night we
had a problem with customers.
>
> 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.
As you said it is manual we can not afford manual solutions.
Thanks
>
>
> > 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]
|