| Bruce de Freitas 2002-11-21, 8:23 am |
| Srini, if you're talking about backing up to disk in a
scheduled DB Maint job.. and then a separate process, to
backup the BAK file on disk to tape, sure... Someone else
will tell you to backup directly to tape, with a 3rd party
tool, I just never see that tape backups under non-DBA
control (usualy) are ever there when you need them, so,
until the day when DBA's control tape backups, know
they're even happening, tapes are rotated, etc.. I greatly
prefer to backup to DISK, then have the Network folk, or
whoever, hopefully backup our backups to tape!
You said database"s", so if a SET of databases and they're
all inter-related, that's harder, if you'd need to recover
a SET of databases always, and not just ONE database from
a set. Best bet there is to take the databases offline,
read-only or whatever, and then backup the SET. For an
online backup in THAT case, I THINK the only option is to
schedule multiple backups at the same exact time and you
PROBABLY have all commited work on both databases backed
up in a set. That's probably not what you need, hopefully.
Why again are you NOT backing up the Trans Log? Are you
(and your data owners) saying it's ok to lose a day's
worth of work, back to the prev day's backup?
Remember to backup to a different DRIVE as the
MDF/LDF's... If a drive goes, and your backups are on the
same drive, you're screwed.... It's good if you go the "I-
don't-trust-tape-backups" route, to have one file server,
and copy the BAK and TRN files over there, for tape backup
from THERE. Then they're in 2 disk places, if that's
possible space-wise... I use ROBOCOPY when possible for
that copying of BAK files around....
Online backups will slow the server down some for your
users but, if the app code isn't too severe on it's own,
there shouldn't be any major performance problems....
Bruce
>-----Original Message-----
>Hi Everybody,
>
>The Problem is, we have an critical Web Application
>accessed by more than 700 users throughout the day (24 *
>7, No down Time during week days). Organisation is asking
>me, is it possible to take Online backup of databases. If
>not, they are asking me supporting documents for Online
>backup failure. And also there will not be any
>transactional / differential backup throughout the day
>only full database backup
>
>Can anybody tell me if we take Online full database
backup
>(not transactional / differential Backup) is there any
>chance of Database dump failure?, if so, can anybody tell
>me what are the problems we can have during online backup
>or any supporting documentations for the failure.
>
>tks in advance,
>Srini
>
>.
>
|