13 November 2007

Tuning Backup & Recovery

A level 0 database backup of my production instance takes over 8 hours, and duplication is just as long, if not longer. I’m going to do some reading and see if we can shore things up. I’ll report back.  The database is around 1.1 terabytes.  Some have told me that their databases of similar size are backed up in only a couple of hours.
My main concern is the duplication, or restore & recovery.  An 8 hour restore/recovery  basically means the loss of a full business day (depending on when it is needed).

No comments:

Post a Comment