Cov txheej txheem:

Yuav txheeb xyuas SQL Server mirroring li cas?
Yuav txheeb xyuas SQL Server mirroring li cas?

Video: Yuav txheeb xyuas SQL Server mirroring li cas?

Video: Yuav txheeb xyuas SQL Server mirroring li cas?
Video: Tsis Muaj Peev Xwm Yuav Ua Li Cas 2024, Kaum ib hlis
Anonim

Saib tus xwm txheej ntawm a database mirroring kev sib tham

Expand Databases, thiab xaiv cov database rau ua iav . Right-click lub database , xaiv Tasks, thiab ces nias Daim iav . Qhov no opens lub Daim iav paj la Database Properties dialog box.

Ua raws li qhov no hauv kev txiav txim siab, kuv yuav ua li cas saib xyuas database mirroring?

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.

Kuj Paub, SQL Mirroring ua haujlwm li cas? Database Daim iav yog siv los txav cov ntaub ntawv pauv ntawm ib qho SQL ntawv Server database (Principal database) rau lwm tus SQL ntawv Server database (Daim iav database) ntawm ib qho piv txwv sib txawv. Hauv SQL ntawv Server Log Shipping thiab Daim iav ua tau ua haujlwm ua ke los muab kev daws teeb meem rau kev muaj siab thiab kev puas tsuaj rov qab los.

Ua raws li qhov no saib, kuv yuav ua li cas thiaj ua tsis tau daim iav hauv SQL Server?

Txhawm rau manually tsis dhau database mirroring

  1. Txuas mus rau tus thawj server piv txwv thiab, hauv Object Explorer pane, nyem lub npe neeg rau zaub mov kom nthuav cov ntoo server.
  2. Nthuav Databases, thiab xaiv cov database kom ua tsis tiav.
  3. Txoj cai-nias lub database, xaiv Tasks, thiab ces nias daim iav.
  4. Nyem Failover.

Kuv yuav paub li cas yog mirroring ua haujlwm?

Saib cov xwm txheej ntawm a database mirroring ntu Expand Cov ntaub ntawv , thiab xaiv cov database ua iav . Right-click lub database , xaiv Tasks, thiab tom qab ntawd nyem Daim iav. Qhov no opens lub Daim iav paj la Database Properties dialog box.

Pom zoo: