August 20, 2016 at 9:33 am
A company offers financial services for its clients.For the company,
when talking about client's financial transactions and their income,
it is very important to not lose any of transactions due to a failure
of an IT system. Every day is generated a large amount of data and for
their management, the company uses SQL Server 2008 R2 instances.
The company needs to build a system which does not allow data loss
even if it happens a small failure of the system, any transaction which
is not committed from the client, should not lose.
The company system should provide a high availability of data in every
moment and the company does not want to change the version of SQL
Server instances because this would lead to additional cost.
The main elements that will effect in a successful implementation of the
company system are:
Infrastructure of the network and servers
Infrastructure used for storing data
Automatic failover
Copies of data shared in more than two servers,placed far from each other
Exploitation of data space through compression technique
Provide a design of an hardware and software system infrastructure of
the company which would provide the solution of each of the above
requirements providing this way a successful implementation.
August 20, 2016 at 3:47 pm
This looks like something from an exam or interview?
You haven't really asked a question, nor tried to answer. I would suggest you look over the HA section in SQL Server 2008 Books Online
August 20, 2016 at 11:36 pm
The first thing I'd recommend is not using 2008 R2.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply