L?I: T?t c? cc thay ?i c th? khng l cu?n l?i khi thu?t s? b?o tr? v?n chuy?n ng nh?p khng thnh cng

D?ch tiu ? D?ch tiu ?
ID c?a bi: 298743 - Xem s?n ph?m m bi ny p d?ng vo.
L?I #: 353349 (SHILOH_BUGS)
L?I #: 353719 (SHILOH_BUGS)
Bung t?t c? | Thu g?n t?t c?

TRI?U CH?NG

Khi b?n thi?t l?p ng nh?p thng qua c s? d? li?u Thu?t s? b?o tr?, v thu?t s? khng hon t?t v? c?a l?i, khng t?t c? nh?ng thay ?i c?a thu?t s? ang cu?n ng?c l?i.

i?u ny c th? gy ra cc sau thng bo l?i x?y ra sau khi b?n s?a ch?a v?n ? ban ?u, v sau ti ch?y thu?t s?:
L?i 14261: Quy ?nh primary_server_name.primary_database_name ('N ') ? t?n t?i.
L?i 14426: M?t mn h?nh v?n chuy?n ng nh?p ? l xc ?nh (...)

NGUYN NHN

C ?c tri hn cng vi?c trn ng nh?p my ch? mn h?nh v?n chuy?n v trn h? ph?c v? chnh:
  • H? ph?c v? chnh: m?t m?c nh?p cho my ch? gim st trong b?ng msdb.dbo.log_shipping_monitor.
  • My ch? gim st: cng vi?c "ng nh?p v?n chuy?n cng vi?c Alert - Sao lu".
  • My ch? gim st: cng vi?c "ng nh?p v?n chuy?n cng vi?c Alert - Khi ph?c".
  • Mn h?nh my ch?: m?t m?c nh?p cho h? ph?c v? chnh trong b?ng msdb.dbo.log_shipping_primaries.
Cc cng vi?c ang c b?i v? c nh?ng hng trong cc log_shipping_primaries b?ng. Trong m?i tr?ng h?p th?t b?i c?a thi?t l?p thu?t s? v?n ? l r?ng log_shipping_primaries v log_shipping_monitor bn ny khng lun lun lm s?ch ln.

CCH GI?I QUY?T KHC

Sau khi ch?y thu?t s? b?o tr? v n khng thnh cng ? t?o ra thi?t l?p ng nh?p v?n chuy?n, b?n ph?i t? d?n s?ch cc b?ng tr?c khi b?n ch?y thu?t s? m?t l?n n?a.
Ty thu?c vo ni m s? th?t b?i l, b?n ph?i ch?y m?t s? cc th? t?c ?c lu tr? ? xa cc m?c nh?p.

B?n c th? ph?i ch?y cc theo th? t?c ?c lu tr? ? lm s?ch v?n chuy?n m?c ng nh?p v cho php cc thu?t s? ? ?c ti ch?y:
  • sp_delete_log_shipping_primary: ? xa h? ph?c v? chnh t? b?ng log_shipping_primary.
  • sp_delete_log_shipping_plan: ? xa b? k? ho?ch tu b Nh?t k?.
  • sp_delete_log_shipping_secondary: ? lo?i b? h? ph?c v? th? c?p t? log_shipping_secondaries b?ng.
  • sp_remove_log_shipping_monitor: Xa Nh?t k? v?n chuy?n mn h?nh thng tin t? log_shipping_monitor b?ng.

T?NH TR?NG

Microsoft ? xc nh?n i?u ny l m?t v?n ? trong SQL Server nm 2000.

THAM KH?O

? bi?t thm chi ti?t, h?y truy c?p trang Web Microsoft sau y cc trang web:

Microsoft SQL Server 2000 Resource Kit; Chng 13

H tr WebCast: Microsoft SQL Server 2000 Log v?n chuy?n

SQL Server 2000 sch tr?c tuy?n

Thu?c tnh

ID c?a bi: 298743 - L?n xem xt sau cng: 26 Thang Tam 2011 - Xem xt l?i: 2.0
p d?ng
  • Microsoft SQL Server 2000 Enterprise Edition
T? kha:
kbbug kbFAQ kbpending kbsqlservlogship kbmt KB298743 KbMtvi
My d?ch
QUAN TRONG: Bi vi?t ny ?c d?ch b?ng ph?n m?m d?ch my c?a Microsoft ch? khng ph?i do con ng?i d?ch. Microsoft cung c?p cc bi vi?t do con ng?i d?ch v c? cc bi vi?t do my d?ch ? b?n c th? truy c?p vo t?t c? cc bi vi?t trong C s? Ki?n th?c c?a chng ti b?ng ngn ng? c?a b?n. Tuy nhin, bi vi?t do my d?ch khng ph?i lc no c?ng hon h?o. Lo?i bi vi?t ny c th? ch?a cc sai st v? t? v?ng, c php ho?c ng? php, gi?ng nh m?t ng?i n?c ngoi c th? m?c sai st khi ni ngn ng? c?a b?n. Microsoft khng ch?u trch nhi?m v? b?t k? s? thi?u chnh xc, sai st ho?c thi?t h?i no do vi?c d?ch sai n?i dung ho?c do ho?t ?ng s? d?ng c?a khch hng gy ra. Microsoft c?ng th?ng xuyn c?p nh?t ph?n m?m d?ch my ny.
Nh?p chu?t vo y ? xem b?n ti?ng Anh c?a bi vi?t ny:298743

Cung cp Phan hi

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com