Viewing 10 posts - 31 through 40 (of 40 total)
Have you tried to drop the existing end points and recreating with the IP Address...
Something like:
CREATE ENDPOINT DB_Mirror
STATE=STARTED
AS TCP (LISTENER_PORT=5022,LISTENER_IP=(192.168.253.2))
...
February 23, 2011 at 1:06 pm
It's not for HA. I've already configured SQL mirroring for 25+ databases on 10 GB NICS for HA.
I'm trying to scale out the application along the X axis -...
February 17, 2011 at 8:02 am
Have you considered block replication software like Steeleye or DoubleTake?
I'm running FusionIO drives (local storage) and in my QA environment configured a GEO Cluster resource on the windows cluster.
Simply put,...
February 17, 2011 at 7:30 am
Hi Everyone -
Thanks for the responses... Much appreciated.
I plan to give this is try in our testing environment.
I'll let you know how it goes.
Thanks again.
Matt
February 9, 2011 at 7:05 am
When you manually failedover from SQL 2008 to SQL 2008 r2, what commands did you run on the principal?
ALTER DATABASE DBName
SET PARTNER FAILOVER
alter database DBName
set partner off
restore database DBName
with recovery
Please...
December 16, 2010 at 12:53 pm
So - have you configured multiple end points on the same SQL Instance and mirrored individual databases to different SQL instances?
IE - The principal server instance (A) has 2 user...
December 13, 2010 at 7:50 am
I was really skeptical when discussing with Microsoft mirroring between SP1 and R2.
The Microsoft tech folks at the PASS SQL Clinic were in complete agreement that mirroring between SP1 and...
December 1, 2010 at 8:52 am
Hi Wayne -
You are right... I just created the index at table creation time.
Matt
November 23, 2010 at 2:11 pm
Hi Lowell –
Thanks for the response… I originally modified the procedure removing the explicit drop w/out much success.
Here’s what we did to alleviate the blocking:
The blocking was caused from the...
November 23, 2010 at 7:39 am
I'm using an ADO connection. The connection works fine when the initial principal SQL service is stopped.
The issue we're facing is the connection doesn't point to the 'new principal' after...
October 21, 2010 at 8:08 am
Viewing 10 posts - 31 through 40 (of 40 total)