I see here that we have a lot of questions about best approach to mirror a single database. I got a new job and people there is under a task to mirror all databases, to a secondary one, in a different city for security (if we lost a server, we have everything on the mirror).
1) to mirror ALL databases, should I repeat the mirroring step for every database?
2)is this the best approach to high availability?
I'm thinking about something with raid, so we have a mirror disk that if a disk fails, there is this secondary ( i just forgot what raid is this, im on the cellphone and will search later).
I think there will be a lot of requests to mirror the data ( it's not going to be synchronous) if we really chose to mirror ALL databases ( there are more than 200).
What would you guys do in this situation? I would even prefer log shipping.
I just found this question but i really need to sleep now. Will study it tomorrow. It says about log shipping too.