235 reputation
211
bio website
location
age
visits member for 3 years, 11 months
seen 2 days ago

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
Jan
2
accepted Dual SMTP Server issue with Unicast Network Load Balancing
Jan
2
comment Dual SMTP Server issue with Unicast Network Load Balancing
Thanks, this is what I ended up doing just before I saw your answer. In the app code, I check if the email is bound to us, if so connect via the private IP to the primary server, otherwise send the mail via its own SMTP server.
Jan
2
asked Dual SMTP Server issue with Unicast Network Load Balancing