Solved

Data replication for governance

Posted on 2012-12-21
4
314 Views
Last Modified: 2013-01-07
Just from a low tech management perspective, to get an idea for data governance more than anything, if say you have a payroll appliction storing sensitive data, can you give me some examples where the database's data could potentially be replicated in locations other than the main application database. I have some idea of replication whereby for high availability the data could be mirrored across several servers. I was just after a list of whereby data for an application may be cloned.

My concerns and the main driver for this question are that if data protection is an area of concern, and auditors just look at the main database for the application, if the data is also replciated in X, y, z location a vulnerability in x, y z location could expose the data to unauthorised access...

These are MS-SQL databases on VMware hosts, Windows 2008 guests...
0
Comment
Question by:pma111
  • 2
4 Comments
 
LVL 42

Expert Comment

by:EugeneZ
ID: 38712711
<can you give me some examples where the database's data could potentially be replicated in locations other than the main application database?>

please clarify your question
0
 
LVL 3

Author Comment

by:pma111
ID: 38712728
I was thinking along the lines of database backups, database mirroring etc.

I.e. a novice may think that an applications data is only in 1 database on one server in the network. But I suspect in high availability environments thats rarely the case. I was trying to get a quick overview of real life examples where data would be replicated in numerous locations therefore security controls need to consider each of these....
0
 
LVL 42

Accepted Solution

by:
EugeneZ earned 250 total points
ID: 38712778
less sensitive data replicated to different servers- less chance\risk to compromise this data...

for HADR-- you need to check with you firm regulations\business requirements\budget..

start with cluster server\ check mirroring and in any case have a  good
\fresh db backup..\have regular db maintenances\
--

but as an example: it is good to have some "test" server(s) with the same security as prod (for sensitive data) to test new application releases prior deployment in prod (MO\Qa servers\environments)..
and  due to avoid any headache-- scrub all sensitive data o test servers before letting testers\qa  to play with a new release
0
 
LVL 119

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE^2)
Andrew Hancock (VMware vExpert / EE MVE^2) earned 250 total points
ID: 38713005
DR Site, Off-Site Safe at Bank (Tape Archives), and The Cloud.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
migration MS SQL database to Oracle 30 59
query execution hang 5 28
Can > be used for a Text field 6 37
VMware Workstation: VM doesn’t start 6 49
When converting a physical machine to a virtual machine using VMware vCenter Converter Standalone or vCenter Converter Enterprise, if an adapter type is not selected during the initial customization the resulting virtual machine may contain an IDE d…
In this article, I show you step by step with screenshots to assist you - HOW TO: Deploy and Install the VMware vCenter Server Appliance 6.5 (VCSA 6.5), with some helpful tips along the way.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
This video shows you how to use a vSphere client to connect to your ESX host as the root user. Demonstrates the basic connection of bypassing certification set up. Demonstrates how to access the traditional view to begin managing your virtual mac…

786 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