Solved

Best practices on backup

Posted on 2010-11-10
4
461 Views
Last Modified: 2012-05-10
Hi All,

For our core system, the database is on a SAN, we have implemented HP data protector, there is online replication to DR site, daily backup onsite backup and daily offsite backup (on tapes).  I would like to know if this is an overkill or best practice for a mission critical system.  If not, what is the best practice?

Thanks,
0
Comment
Question by:ISS_Expert
  • 2
4 Comments
 
LVL 23

Accepted Solution

by:
jakethecatuk earned 250 total points
ID: 34100500
Backups are only one small part of the DR solution.

The first thing to understand is what is the minimum downtime that the business can suffer.  If it's 24hours, then daily backups are OK.  If it's 15 minutes, then you need to make sure that you are backing up all your changing data between full backups.

A lot will also depend on what data you are backing up.  If for example you are running a heavy transaction based SQL server, then you may need more backups than a lightly used web server.

Having HP data protector is great - but what happens if corruption creeps in during the day and you have to roll your data back 1hour?  Could you do that?  How would you do it?

You also need to weigh up the risk element vs. the cost/performance impact of taking the backups.

With backups, defining best practice is difficult because each scenario is very different.

Not really an answer for you...just a quick answer between meetings :)
0
 
LVL 25

Assisted Solution

by:madunix
madunix earned 250 total points
ID: 34100824
We have 3 sites replication using IBM technology (Metro and Global mirror) DS8100 SAN storage to allocate our systems. I have SAN to SAN replication synchronous over Dark fiber. (distance=5Km) with zero lost data Production site and Resumption site, and asynchronous replication over MPLS with 35Mbps (distance=150Km) Resumption Site and SR site.

We use ibm tivoli storage manager Storage management software  to automates data backup and restore functions for clients and server (Microsoft, Linux, AIX , Oracle, MSSQL)
http://www-01.ibm.com/software/tivoli/products/storage-mgr/

"Metro Mirror is generally considered a campus-level solution, where the systems are located in fairly close proximity, such as within the same city. However, the distance supported will vary based on the write intensity of the application and the network being used. In general, with adequate resources, most customers find up to a 50-kilometer distance acceptable with some customers implementing up to a 300-kilometer distance."

"With Global Mirror, the target site may trail the production site by a few seconds. The frequency of creating a consistency group is a tunable parameter, and you?ll need to balance your recovery point objective with the performance impact of creating a consistency group. Many customers find a three- to five-second consistency group achievable (i.e., in a disaster, you?d lose the last three to five seconds of data)."

0
 
LVL 25

Expert Comment

by:madunix
ID: 34106138
so your doing all the right things....
0
 
LVL 1

Author Closing Comment

by:ISS_Expert
ID: 34155207
Thanks Guys.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
shadow copies 7 69
Perc 6/i question adding more drives/arrays 5 49
NAS with google authentication 6 60
Symantec replaced by VEEAM 6 39
VM backups can be lost due to a number of reasons: accidental backup deletion, backup file corruption, disk failure, lost or stolen hardware, malicious attack, or due to some other undesired and unpredicted event. Thus, having more than one copy of …
Create your own, high-performance VM backup appliance by installing NAKIVO Backup & Replication directly onto a Synology NAS!
In this Micro Tutorial viewers will learn how to use Windows Server Backup to create full image of their system. Tutorial shows how to install Windows Server Backup Feature on Windows 2012R2 and how to configure scheduled Bare Metal Recovery backup.…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now