Hi everyone need any site for mean time to recovery process for anything like mirroing, logshipping,replication etc... If our bussiness is in any HA(High availability) or wihtout HA also if anything happend how much time to take recovery the data and running the bussiness? Can you please share your ideas with me if anything is happned to our transactional database how we can recover the data with in minimal time?
Recovery is all about backup. High availability is all about multiple locations and multiple servers and mechanisms to make sure that data is in multiple locations so that if one location goes, the other location is available. These are actually two different problems. The interesting thing is, if you set up HA, you still need to set up backups. You don't get away from backups no matter what. I always suggest going to the business and finding out, for each application, how much down time can be accepted. Then find out how much data can be lost. The answer to both these is always "zero" in the initial conversation, but you need to persevere until you get a good and accurate answer. If that answer is "zero" then you need to spend a lot of money setting up mirroring and building a very sophisticated backup process and this will be extremely expensive. There are no hard set of rules, for "X" downtime do "Y." In general you have to look at the needs of the business and the amount of money you have to spend and then start making choices from there.