Why it is important to store your database in multiple locations? and how it can be achieved in the easiest and reliable manner.
Printable View
Why it is important to store your database in multiple locations? and how it can be achieved in the easiest and reliable manner.
Multiple locations are used for secure data retention. If something happens to one, then you at least have another copy.
Ok, but how we can achieve this in easiest way as I think storing data in multiple locations is not an easy process and might also depends on the size of database.
I think you're misunderstanding the implementation. You don't read from/write to both at the same time. You have an active database and one backup. At given increments you backup the active database to another location. It's basically a simple copy procedure.
Thanks, PeejAvery for clarifying my doubts as now I got it.