September 28, 2009 at 12:00 pm
Hi,
This is my first post on SQL Server central, and I'm hoping someone can give some advice on a replication scenario.
We currently have a single SQL 2005 Standard edition hosting 15 databases, frequently with one application accessing more than one database. We are having a web portal built remotely with a web hosting company who also has a datacentre.
We are looking to put another SQL 2005 server in their datacentre and replicate all our databases to it over a 5 meg Fiber link. We were planning on their SQL database on their web server would run all queries from our remote SQL in their datacentre, and any writing (minimal) from their web server's SQL would be done back to our main database at our head office.
I am unsure which replication technology to consider. Should the primary site fail, or the site become inaccessible, I would want all direction to go to the DR SQL sitting in the datacentre (I know it would be slow).
I thought of mirroring first, but we are not using Enterprise, and I understand that the read through the mirror to the Web server is done via database snapshots, only avail on SQL Enterprise. Even with Enterprise hi performance mode mirroring may not be a possibility due to the applications accessing multiple databases.
I am also looking at Double-take to replicate the server, but I am unsure if the remote server would be available for reads from the web server.
I'm not sure how well Log shipping or replication would fit into this scenario.
Any suggestions?
Thanks,
B
October 2, 2009 at 11:14 am
Anyone??? Or am I asking this in the wrong place?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply