SEO

#1 (**permalink**) 02-26-2008, 04:17 PM

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

#2 (**permalink**) 02-26-2008, 04:17 PM

Could you use split mirror and log shipping:
http://www-106.ibm.com/developerwork...04mcinnis.html

http://www-106.ibm.com/developerwork...0204quazi.html

maniac wrote:
> 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

#3 (**permalink**) 02-26-2008, 04:17 PM

maniac wrote:
> 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?
>

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! =-----

#4 (**permalink**) 02-26-2008, 04:17 PM

"maniac" <libi.maniace@dillards.com> wrote in message
news:527eb8ee.0312021256.5c10972@posting.google.co m...
> 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

You need to identify DB2 version number and operating system.

#5 (**permalink**) 02-26-2008, 04:17 PM

> Are there any
> suggestions for a backup solution that would allow us to minimize
> our outage?

Migration :-)

#6 (**permalink**) 02-26-2008, 04:18 PM

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:

> maniac wrote:
> > 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?
> >
>
> 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! =-----

#7 (**permalink**) 02-26-2008, 04:18 PM

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.400178$HS4.3232861@attbi_s01...
> > Are there any
> > suggestions for a backup solution that would allow us to minimize
> > our outage?
>
> Migration :-)
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Backups for e commerce site