Mean time to recovery docs?

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?

more ▼

asked Dec 14, 2011 at 02:08 AM in Default

Naren gravatar image

27 17 18 19

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.
more ▼

answered Dec 14, 2011 at 02:28 AM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
103k 19 21 74

That is great explanation .... If I am using mirroring and maintain good backup stratgy then if anything is happend to primary server then how many ways to bring mirror to online? And what is the down time and is there any data lose happend at any situation?
Dec 14, 2011 at 04:12 AM Naren

The mirror will come online automatically. That's the whole idea behind it. Just remember, mirroring is set up per database. It's not a server thing. Down time is the amount of time it takes to switch connections... near zero in most circumstances. Your app has to be set up with a connection string so that it takes mirroring into account.

Data loss, completely depends on how you program. Let's imagine a incomplete transaction. The server goes offline, that transaction goes away. Does your application know enough to resubmit the transaction? It's not something the database or the database server can handle. It's up to the app.

There's a bunch more detail on this. I'm taking a week long class on the 2012 Always On technology at the end of January. I'll know more then.
Dec 14, 2011 at 05:04 AM Grant Fritchey ♦♦
Thank you....
Dec 14, 2011 at 08:08 AM Naren
While failover the principle to mirror server what are the steps need to follow? And is need to change connection string also?
Dec 14, 2011 at 08:10 AM Naren
You can look that up in the Books Online. You shouldn't have to modify the connection string for failover. You modify it to show that you're setting up a mirror situation and then the connections are routed to whichever server is online. No other modifications necessary.
Dec 14, 2011 at 08:34 AM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Dec 14, 2011 at 02:08 AM

Seen: 1673 times

Last Updated: Dec 14, 2011 at 02:09 AM