Re: Data Warehouse Backups

Mike

I thought that was a SMALL data warehouse! ;)

A couple of comments. Firstly, make as much of the database read-only as possible, then you only need to back it up once (in theory - I know practically this is not the case). Secondly, look at whether the data can be reloaded more quickly than it can be recovered (SQL*Loader direct and parallel), in which case it's less important to back it up.

HTH. Pete

Mike Vergara wrote:

> Mike Vergara wrote in message <7sbqaj$2p1_at_dfw-ixnews12.ix.netcom.com>...
> >Hey DBAs:
> >
> >We're working on our first data warehouse project. The software
> >vendor is MicroStrategy. They're telling us that our data warehouse
> >(mainly retail shopping data) will grow to about 700MB in the next
> >year.
> Hey everyone...I meant *700GB*. Oops.
>
> >
> >My question to any other data warehouse DBAs is "How do you
> >back up that much stuff?" We're using Legato Networker as our
> >recording system, but what do YOU do? What are your experiences?
> >
> >Respond to the group or to my e-mail and I will summarize back to
> >the list.
> >
> >Thanks,
> >Mike
> >
> >
> >
> >

Received on Thu Sep 23 1999 - 08:33:20 CDT