Yuav ua li cas pab ib txwm nyob rau hauv SQL Server?
Yuav ua li cas pab ib txwm nyob rau hauv SQL Server?

Video: Yuav ua li cas pab ib txwm nyob rau hauv SQL Server?

Video: Yuav ua li cas pab ib txwm nyob rau hauv SQL Server?
Video: Kev Muag Khoom thiab Kev Sib Cuam Tshuam Nrog Cov Neeg Qhua Yam Muaj Kev Nyab Xeeb 2024, Lub peb hlis ntuj
Anonim

Txoj nyem rau ntawm TCP / IP nkag thiab xaiv Pab . Thaum koj tseem nyob hauv SQL Server Configuration Manager, right click on SQL Server Cov kev pabcuam qhib lub Properties dialog box. Coj mus rhaub rau AlwaysOn High Availability tab, thiab xaiv Qhib AlwaysOn Muaj Pawg Pab Pawg kos lub thawv.

Yog li ntawd, yuav ua li cas pab ib txwm On feature hauv SQL Server?

Hauv SQL Server Configuration Manager, nyem SQL Server Services, right-click SQL Server () lub npe nyob qhov twg server piv txwv li koj xav tau pab ib txwm Ntawm Availability Groups, thiab nyem Properties. Xaiv tus Ib txwm Ntawm High Availability tab.

Muaj pes tsawg AlwaysOn muaj pab pawg tuaj yeem teeb tsa hauv ib txwm nyob? Koj ua tau muaj ntau tshaj ib AlwaysOn Availability Group ntawm koj qhov piv txwv, tab sis databases tsis tuaj yeem koom nrog ntau dua ib qho pab pawg.

Kuj kom paub, dab tsi yog SQL Server Ib txwm Nyob?

SQL Server AlwaysOn muab ib tug high-muaj peev xwm thiab Disaster-recovery daws rau SQL Server 2012. Nws ua rau kev siv uas twb muaj lawm SQL Server nta, tshwj xeeb yog Failover Clustering, thiab muab cov peev txheej tshiab xws li pab pawg muaj. Nws aims muab ntau granular tswj kom ua tiav High Availability.

Koj teeb tsa AlwaysOn pab pawg li cas?

Qhib SQL Server Kev teeb tsa Tus thawj tswj. Muab ob npaug rau-nias SQLServer (MSSQLSERVER) kev pabcuam los qhib lub Properties dialog box. Hauv Properties dialog box, xaiv qhov AlwaysOn Siab Muaj tab. Kos lub Enable AlwaysOn Availability Groups kos lub thawv. Qhov no yuav ua rau koj rov pib qhov kev pabcuam SQL Server.

Pom zoo: