Cov txheej txheem:

Puas yog mirroring muaj nyob rau hauv SQL 2016?
Puas yog mirroring muaj nyob rau hauv SQL 2016?

Video: Puas yog mirroring muaj nyob rau hauv SQL 2016?

Video: Puas yog mirroring muaj nyob rau hauv SQL 2016?
Video: Puas yog luag dag koj xwb | Kawm muas 2024, Hlis ntuj nqeg
Anonim

Raws li lub Ob Hlis 2016 , Microsoft hais tias: "[Database Daim iav ] yuav raug tshem tawm hauv Microsoft yav tom ntej version SQL Server . Tsis txhob siv cov yam ntxwv no hauv kev tsim kho tshiab, thiab npaj los hloov cov ntawv thov uas tam sim no siv cov yam ntxwv no. Siv AlwaysOn Availability Groups xwb."

Raws li, database mirroring hauv SQL Server 2016 yog dab tsi?

Database Mirroring yog siv los txav cov database kev pauv nyiaj los ntawm ib qho SQL Server database (Principal database ) rau lwm tus SQL Server database (Daim iav database ) ntawm ib qho piv txwv sib txawv. Hauv SQL Server Log Shipping thiab Daim iav tuaj yeem ua haujlwm ua ke los muab cov kev daws teeb meem rau kev muaj siab thiab kev puas tsuaj rov qab los.

Tom qab ntawd, lo lus nug yog, dab tsi yog qhov yuav tsum tau ua ua ntej rau kev tsom xam database? Yam yuavtsum tau kawm uantej

  • Rau qhov kev sib tham mirroring yuav tsum tau tsim, cov koom tes thiab cov neeg pov thawj, yog tias muaj, yuav tsum tau khiav ntawm tib version ntawm SQL Server.
  • Ob tus neeg koom tes, uas yog tus thawj tswj hwm tus thawj tswj hwm thiab daim iav neeg rau zaub mov, yuav tsum tau khiav tib tsab ntawm SQL Server.
  • Lub database yuav tsum siv tus qauv rov qab tag nrho.

Ntawm no, dab tsi yog mirroring hauv SQL?

SQL ntawv Server database tsom iav yog ib qho kev puas tsuaj rov qab thiab cov txheej txheem muaj peev xwm uas muaj ob SQL ntawv Server piv txwv ntawm tib lub tshuab lossis sib txawv. Ib SQL ntawv Server instance ua raws li qhov piv txwv tseem ceeb hu ua tus thawj tswj hwm, thaum lwm qhov yog a iav piv txwv hu ua iav.

Kuv yuav saib xyuas database mirroring li cas?

Saib xyuas Database Mirroring

  1. Qhib Management Studio, thiab txuas mus rau tus thawj tswj hwm lossis daim iav server.
  2. Qhib Databases, thiab right-click lub hauv paus database.
  3. Xaiv Tasks, thiab tom qab ntawd nyem Launch Database Mirroring Monitor.
  4. Nyem Action menu, thiab xaiv Sau Npe Mirrored Database.

Pom zoo: