Desktop

Ask something
Discussion Locked

Database backups industry standard

0 helpful
2 replies

by manojit

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I wanted to know what is the industry standard to back up databases of OLTP systems ( database sizes around 150 GB) for full and incremental backups.

2 replies

by jereg

The short answer is:daily. If you check some of the DR vendors web sites, like Veritas, You find lots of info on backup schedules. It depends on your company, legal requirements, etc. as to how you backup. I do full daily backups myself.
Good luck.

by manojit

Makes sense but I was looking at the practicality of the solution of daily backups for more than 150Gb databases, It takes anything from 2-3 hrs to backup it to disk or tape and so do we generally live it with as a good DBA practise.

This discussion is closed to new replies.