Re: cold backup over weekend in archive mode?

Susan,

This is perfectly acceptable and works well. To recover a database, you can restore from you cold backups and then apply the archived logs to bring it up to date. Just because you are running in ARCHIVEMODE does not mean that you have to do a Hot backup. Once you have settled on this as a backup strategy, make sure that you test, test and test your recovery procedures.

HTH,
Brian

susana73_at_hotmail.com wrote:
>
> Hi there,
>
> I am wondering if I can do a cold backup of the entire database only on
> weekend(Sat and Sun) and backup the archive logs daily? Am I able to
> recover the database using the archives then? Is it too risky to that?
>
> Thanks.
>
> Susan
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================