Collocating

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Next - 20 Jul 2005 06:46 GMT

Hello : )

This Thursday 21st, I have a second interview for a DBA position. I have
been looking for an opportunity like this for awhile now and I hope I don't
blow it.

My question is regarding replication/synching for SQL Servers at different
locations. One of the first tasks (if I am hired) will be to find a location
to install and set up redundant SQL Servers. The reason they want to do this
is because they recently had an extended power loss and their servers where
down for several hours.

I am sure I will be asked during the interview how I will go about doing
this. Does anyone have any advice on how to answer?

I have been working with single Production servers at several companies over
the past 7 years, but
I have no expirence with collocation, and only "playing around" expierence
with replication. I am not afraid of this task and am looking forward to a
challange like this.

I want to be sure that I answer the question intellegently.

Thanks in advance for your support!
Aaron

Reply to this Message

Kevin3NF - 20 Jul 2005 15:02 GMT

Key points:

Replication is not always a good way to implement disaster recovery....it
makes changed to your database and servers (as well as adding a whole new
layer of DBA effort)

Log shipping is an option (easy if you have Enterprise Edition)

3rd party tools such as Double-take from http://www.nsisoftware.com/ may
also be an option.

It really depends on their tolerance for downtime, willingness to pay for a
solution and size of the database (its much easier to set up DR for 20mb
than 20TB)

Signature

Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions

> Hello : )
>
[quoted text clipped - 26 lines]
> Thanks in advance for your support!
> Aaron

Reply to this Message