Viewing 4 posts - 1 through 4 (of 4 total)
I appreciate all input. Below is my update
1) Wait stats
WaitType ...
August 18, 2014 at 3:22 pm
It works after changed backup priority.
USE [master]
GO
ALTER AVAILABILITY GROUP [AG1]
MODIFY REPLICA ON N'SQL2' WITH (BACKUP_PRIORITY = 80)
GO
USE [master]
GO
ALTER AVAILABILITY GROUP [AG1]
MODIFY REPLICA ON N'SQL1' WITH (BACKUP_PRIORITY = 20)
GO
It was 50/50...
June 9, 2014 at 9:24 pm
How about System Center Operations Manager 2007?
Can we use it for us? I didn't use it much before.
December 24, 2009 at 12:23 am
Fixed. I can connect it with ssms from remote client now.
just delete the registed value in HKLM\software\wow6432node\microsoft\microsoft sql server\MSSQL.1... more...
December 22, 2009 at 1:17 am
Viewing 4 posts - 1 through 4 (of 4 total)