Backups for e commerce site

[maniac]

We are looking for a backup solution for our e-commerce site.
We need to be up 24/7 and currently we are taking a 1 1/2 hour
outage each weekend for an off-line backup. Are there any
suggestions for a backup solution that would allow us to minimize
our outage?

Thanks

[Blair Adamache]

Re: Backups for e commerce site

Could you use split mirror and log shipping:

http://www-106.ibm.com/developerworks/db2/library/techarticle/0304mcinnis/0304mcinnis.html

http://www-106.ibm.com/developerworks/db2/library/techarticle/0204quazi/0204quazi.html

maniac wrote:[color=blue]
> We are looking for a backup solution for our e-commerce site.
> We need to be up 24/7 and currently we are taking a 1 1/2 hour
> outage each weekend for an off-line backup. Are there any
> suggestions for a backup solution that would allow us to minimize
> our outage?
>
> Thanks[/color]

[Ian]

Re: Backups for e commerce site

maniac wrote:[color=blue]
> We are looking for a backup solution for our e-commerce site.
> We need to be up 24/7 and currently we are taking a 1 1/2 hour
> outage each weekend for an off-line backup. Are there any
> suggestions for a backup solution that would allow us to minimize
> our outage?
>[/color]

Stop using offline backups? You don't need them to recover your
database, online backups should be fine.






-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

[Mark A]

Re: Backups for e commerce site

"maniac" <libi.maniace@d illards.com> wrote in message
news:527eb8ee.0 312021256.5c109 72@posting.goog le.com...[color=blue]
> We are looking for a backup solution for our e-commerce site.
> We need to be up 24/7 and currently we are taking a 1 1/2 hour
> outage each weekend for an off-line backup. Are there any
> suggestions for a backup solution that would allow us to minimize
> our outage?
>
> Thanks[/color]

You need to identify DB2 version number and operating system.

[Mark Townsend]

Re: Backups for e commerce site

> Are there any[color=blue]
> suggestions for a backup solution that would allow us to minimize
> our outage?[/color]

Migration :-)

[Fan Ruo Xin]

Re: Backups for e commerce site

Consider Blair and Ian's suggestion.
I would suggest Split/Mirror backup (I/O suspend) first.
And you also can use Online backup - db2 udb supports both db and
tablespaces online backup.


Ian wrote:
[color=blue]
> maniac wrote:[color=green]
> > We are looking for a backup solution for our e-commerce site.
> > We need to be up 24/7 and currently we are taking a 1 1/2 hour
> > outage each weekend for an off-line backup. Are there any
> > suggestions for a backup solution that would allow us to minimize
> > our outage?
> >[/color]
>
> Stop using offline backups? You don't need them to recover your
> database, online backups should be fine.
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----== Over 100,000 Newsgroups - 19 Different Servers! =-----[/color]

[kpware]

Re: Backups for e commerce site

Commerce Sites tend to have considerable static data. The only thing that
needs to get backed up on a regular basis is the transactional data.
Therefore place all transactional tables in one or two tablespaces and to a
TS level backup.
"Mark Townsend" <markbtownsend@ attbi.com> wrote in message
news:Viczb.4001 78$HS4.3232861@ attbi_s01...[color=blue][color=green]
> > Are there any
> > suggestions for a backup solution that would allow us to minimize
> > our outage?[/color]
>
> Migration :-)
>[/color]