SQL server 2005 mirror problem
Posted on 2013-06-03
right now we found the SQL server 2005 with SP2 mirror replication keep disconnect/pause without any reason, that DR server runs on a VM and we did change to a better VM.
before we switch to a new VM, all mirror will disconnect/pause at the same time and we have 20-30 DB doing mirror at the same time,
after we move the VM to a better hardwrae, the number of disconnect/pause mirror is much less, around 6-7 each time.
so it is the VM does matter.
May I know it could help to upgrade SQL server 2005 from SP2 to SP4?