Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the best scenario for database backup?

user-image
Question added by Raafat Sallam , Organizational Development and Training Consultant , Training Centers, Marketing Organizations.
Date Posted: 2013/12/17
Mohammad Tohamy Hussein Hussein
by Mohammad Tohamy Hussein Hussein , Chief Executive Officer & ERP Architect , Egyptian Software Group

Dual, daily incremental backup with one copy on site and the other offsite with attention to the lifetime of the used media, and a monthly resorability test.

Jalal Raza Pintu
by Jalal Raza Pintu , freelance Database designer,software devloper,project analyst , K2 Infotech

for orgnisation which size small, i prefer to make full daily backup with overwrite, for medium full daily backup without overwrite and for big size and stretegic database i suggest ot take full backup with log and datafiles hourly and also suggest to backup drive is not same for full backup log files and datafiles.

Rajesh K
by Rajesh K , ISP Manager , CENPAC NET INC

Daily incremental Backup(T log),Weekly differentail backup, Monthly full backup with integrity check.

Keep backup to a tape or offsite also.  

Then remove older backup files by keeping a offsite backup. 

 

fathi salih
by fathi salih , Internal Auditor / IT auditor , Central Bank Of Sudan

It is good practice to back up to disk, transfer to tape and store tapes offsite for disaster recovery (DR). The backups to disk are faster; DBAs have more control and can better monitor these and, with this method, DBAs hold two sets of backups—one on disk, the other on tape.

During restore, if backups are still on disk, it will be a faster restore, reducing mean time to recover (MTTR).

Real Time remote site backup 

Tariq Ali
by Tariq Ali , Deputy Manager IT , Kohat Cement Company Limited

If possible daily full backup and incremental backup hourly

Mamdouh AlSharif
by Mamdouh AlSharif , Freelance Data Manager, Manipulator and Analyst , Freelance

best = depends on budget; for me = (local replication + remote replication) on separate servers

Olusesi Ibrahim Adebisi
by Olusesi Ibrahim Adebisi , Senior DBA and Technical Lead Database Projects , MTN Nigeria

The best senerios for database backup is to get the most consistent backup of the database with little no performance issue.

 

In order to achieve this scenerio you need to have production and disaster site configured for the database.

The backup of the database is best taken from the DR site to ensure zero performance issue with the production. Since the backup is running from the DR site you can schedule several incremental and full backups  in accordance with transaction rate of the database.

More Questions Like This