Reputation
245
Next privilege 250 Rep.
View close votes
Badges
3 12
Impact
~14k people reached

  • 0 posts edited
  • 0 helpful flags
  • 12 votes cast
Feb
14
comment High Availability with 3 servers: To virtualise or not?
Thanks TomTom. So in this case, virtualisation is no benefit? I know there is VMware Fault Tolerance?
Feb
14
comment High Availability with 3 servers: To virtualise or not?
@JakeRobinson hosted with a managed provider at a datacenter
Feb
14
comment High Availability with 3 servers: To virtualise or not?
In practice what do people do? Is it better to separate out the web/db servers rather than have them on one machine? I think so but budget constraints mean this is only possible if we virtualise.
Feb
14
revised High Availability with 3 servers: To virtualise or not?
added 155 characters in body
Feb
14
asked High Availability with 3 servers: To virtualise or not?
May
3
accepted MSSQL Mirroring Failover: Login failed for user
May
3
awarded  Supporter
May
3
comment How to: Hot Standby SQL Server in another datacenter?
Thanks for the answer, yes I meant once we failover can we accept writes. Looks like the answer is no. Would have no way of restoring a tail log backup as I'm assuming we failover because the whole datacenter is down and thus I could not take a backup. I guess then log shipping with DNS failover for traffic, leaving the DB in read-only mode...
May
3
comment How to: Hot Standby SQL Server in another datacenter?
Great to hear from you. We already use mirroring for auto failover for within the datacentre. So the only way I see being able to failover in the event of the DC being down is to direct traffic there with DNS. If it were a client app you could direct the DB connection to the secondary site if the primary is down. For us, the app is in the same location as the DB server, so we either run the primary or if down, the secondary. Seems the secondary would have to be read only and would have to rely on DNS failover. Unless you have any other ideas?
May
2
revised How to: Hot Standby SQL Server in another datacenter?
edited title
Apr
28
awarded  Editor
Apr
28
revised How to: Hot Standby SQL Server in another datacenter?
added 79 characters in body
Apr
27
comment How to: Hot Standby SQL Server in another datacenter?
I understand these concerns, thanks. However this question is aimed at finding out how to do the database stuff.
Apr
27
asked How to: Hot Standby SQL Server in another datacenter?
Apr
9
awarded  Student
Apr
9
awarded  Teacher
Apr
9
comment MSSQL Mirroring Failover: Login failed for user
Just to add, this works.
Apr
9
answered MSSQL Mirroring Failover: Login failed for user
Apr
9
asked MSSQL Mirroring Failover: Login failed for user
Jan
2
awarded  Scholar