b? my c s? d? li?u ?c nhn i b? ng?t k?t n?i sau khi b?n kh?i ?ng l?i my nhn b?n b? my c s? d? li?u trong SQL Server 2005, SQL Server 2008 hay SQL Server 2008 R2

D?ch tiu ? D?ch tiu ?
ID c?a bi: 2490051 - Xem s?n ph?m m bi ny p d?ng vo.
Bung t?t c? | Thu g?n t?t c?

? Trang ny

Tri?u ch?ng

H?y xem xt k?ch b?n sau y:
  • B?n c m?t my tnh ang ch?y m?t tr?ng h?p th? hai c?a Microsoft SQL Server 2005, Microsoft SQL Server 2008 hay Microsoft SQL Server 2008 R2 trong gng hai my ch? b? my c s? d? li?u.
  • Vi?c s? d?ng CPU ?t ?n 100 ph?n trm trn my tnh, v b?n khng th? t?t my b?n ghi d?ch v? SQL Server b?ng cch s? d?ng cng c? qu?n l? SQL Server.
  • B?n k?t thc ti?n tr?nh c?a tr?ng h?p th? hai c?a SQL Server b?ng cch s? d?ng Task Manager.
  • B?n kh?i ?ng l?i tr?ng h?p th? hai c?a SQL Server.
Trong tr?ng h?p ny, t?t c? cc b? my c s? d? li?u ?c nhn i ang ? trong m?t tram u "? ng?t k?t n?i" ho?c "Trong ph?c h?i". Ngoi ra, m?t thng bo l?i tng t? nh sau y ?c k nh?p trong SQL Server error log cho m?i c s? d? li?u:
B? qua ph?c h?i b? my c s? d? li?u 'b? my c s? d? li?u tn' b?i v? n ?c nh d?u ki?m l m?t b? my c s? d? li?u khng th? ti?p c?n ph?n nh b? my c s? d? li?u. M?t v?n ? t?n t?i v?i phin mirroring. Phin giao d?ch ho?c thi?u m?t ?i bi?u ho?c cc thng tin n?i k?t lin h? b? h?ng do v?n ? v?i cc lin k?t, endpoint c?u h?nh ho?c quy?n (?i v?i my ch? ti kho?n ho?c b?o m?t gi?y ch?ng nh?n). ? ?t ?c quy?n truy c?p vo b? my c s? d? li?u, ch? ra nh?ng g? ? thay ?i trong c?u h?nh phin v hon tc thay ?i.

Nguyn nhn

V?n ? ny x?y ra do cc v?n ? trong b? my c s? d? li?u SQL Server ph?n nh hai i?m cu?i.

? phn gi?i

? gi?i quy?t v?n ? ny, s? d?ng cc phng php sau. N?u phng php ?u tin khng gi?i quy?t v?n ?, s? d?ng phng php th? hai.

Phng php 1

Ti ch? endpoint trn my nhn b?n b? my c s? d? li?u. ? lm i?u ny, h?y lm theo cc b?c sau:
  1. Trn b? my c s? d? li?u chnh, th?c hi?n k?ch b?n SQL sau y ? ngn ch?n i?m cu?i:
    ALTER ENDPOINT <Endpoint Name> STATE=STOPPED
  2. Th?c hi?n k?ch b?n SQL sau y ? kh?i ?ng l?i i?m cu?i:
    ALTER ENDPOINT <Endpoint Name> STATE=STARTED
Lu ? N?u cc giao ti?p gi?a l hai i?m cu?i khng kh?i ?ng l?i sau khi b?n th?c hi?n cc k?ch b?n, th?c hi?n cc t?p l?nh trn my nhn b?n b? my c s? d? li?u. Tuy nhin, b? my c s? d? li?u c th? nh?p m?t nh n?c "B? treo" sau khi b?n lm i?u ny. N?u v?n ? ny x?y ra, th?c hi?n k?ch b?n SQL sau y:
ALTER DATABASE <Database Name> SET PARTNER RESUME

Phng php 2

Xo v ti t?o b? my c s? d? li?u ph?n nh hai i?m cu?i trn c? hai my ch?.

T?nh tr?ng

Microsoft ? xc nh?n r?ng y l m?t v?n ? trong s?n ph?m c?a Microsoft ?c li?t k trong ph?n "p d?ng cho".

Thu?c tnh

ID c?a bi: 2490051 - L?n xem xt sau cng: 30 Thang Ging 2013 - Xem xt l?i: 1.0
p d?ng
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2005 Evaluation Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
T? kha:
kbsurveynew kbtshoot kbexpertiseadvanced kbmt KB2490051 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: 2490051

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