If you have servers which hosts database mirroring and you want to install the service pack on those systems and you are trying to find out the order in which you need to do it then, here is the order in which you need to install service pack or a hotfix on the systems which hosts Database Mirroring.
- Backup the principal
- If you are using a witness, remove it from mirroring
- Upgrade the mirror
- Failover to mirror
- Upgrade original principal/current mirror
- If you wish to fail back to original principal continue on; otherwise, proceed to step 8
- Failover to original principal
- If you are using a witness, add it back into mirroring
For more information refer to the following article to know the entire process for upgrading both the principal and mirror servers.
http://technet.microsoft.com/ en-us/library/bb497962(SQL.90) .aspx
http://technet.microsoft.com/
1 comment:
Mua vé tại Aivivu, tham khảo
vé máy bay đi Mỹ
giá vé máy bay mỹ về việt nam
vé máy bay từ đức về việt nam giá rẻ
vé máy bay từ nga về việt nam bao nhiêu
vé máy bay từ anh về việt nam
chuyến bay từ châu âu về việt nam
chuyen bay danh cho chuyen gia
Post a Comment