Viewing 5 posts - 1 through 6 (of 6 total)
Ok, this is getting ridiculously painful... here's what I did so far:
-deleted previously created endpoints and ran alter db set partner off
-went into SQL Server Config Manager and made sure...
July 23, 2015 at 5:55 am
Perry Whittle (7/22/2015)
check the endpoints to make sure theyre started
yes they are started, here's the status on principal
SQLSERVER1_EndPoint DATABASE_MIRRORING STARTED 6024 172.16.0.83
on mirror
SQLSERVER1_EndPoint DATABASE_MIRRORING ...
July 22, 2015 at 7:19 am
Perry Whittle (7/22/2015)
rcaballero (7/22/2015)
- Database mirroring has been terminated for database 'DBName'. This...
July 22, 2015 at 6:04 am
every time I run the ALTER..SET PARTNER on the PRIMARY, I get these logged under the SQL Logs
- Database mirroring has been terminated for database 'DBName'. This is an informational...
July 22, 2015 at 5:13 am
these commands
---ON Mirror---
CREATE ENDPOINT SQLSERVER1_EndPoint
STATE=STARTED
AS TCP (LISTENER_PORT=6025,LISTENER_IP=(172.16.0.81))
FOR DATABASE_MIRRORING (ROLE=PARTNER)
---ON Principal---
CREATE ENDPOINT SQLSERVER1_EndPoint
STATE=STARTED
...
July 21, 2015 at 10:40 am
Viewing 5 posts - 1 through 6 (of 6 total)