Kh?c ph?c: M?i s?n c nhm thu?t s? t?o ra k?ch b?n b? qua cc b?c ? gia nh?p m?t b? my c s? d? li?u trung h?c m?t nhm s?n c trong SQL Server 2012

D?ch tiu ? D?ch tiu ?
ID c?a bi: 2645920 - Xem s?n ph?m m bi ny p d?ng vo.
Microsoft phn ph?i Microsoft SQL Server 2012 b?n s?a l?i nh l m?t t?i v? t?p. B?i v? cc b?n s?a l?i tch l?y, m?i b?n pht hnh m?i c ch?a t?t c? cc hotfix v t?t c? cc s?a l?i b?o m?t ?c nh km v?i tr?c nm 2012 Server SQL S?a ch?a pht hnh.
Bung t?t c? | Thu g?n t?t c?

Tri?u ch?ng

Xem xt k?ch b?n sau y:
  • B?n t?o ra m?t nhm s?n c b?ng cch s? d?ng thu?t s? Nhm M?i c s?n trong Microsoft SQL Server Management Studio cho Microsoft SQL Server 2012.
  • B?n ch?n cc ?y ? ho?c cc Tham gia ch? Tu? ch?n ?ng b? ha d? li?u trn cc Ch?n ?ng b? ha d? li?u ban ?u c?a b?n Trang.
  • Trn cc Tm t?t Trang, b?n nh?p vo K?ch b?n ? nh?n ?c t? ?ng t?o ra script.
Trong tr?ng h?p ny, cc k?ch b?n t?o ra b? qua cc b?c tham gia m?t b? my c s? d? li?u th? c?p hi?n c ? nhm s?n c. V? v?y, n?u b?n c? g?ng s? d?ng cc k?ch b?n ? t?o ra m?t nhm s?n c, nhm s?n c khng th? ?n tr?c tuy?n.

Gi?i php

b?n ghi d?ch v? gi thng tin cho SQL Server 2012

? gi?i quy?t v?n ? ny, c ?c gi b?n ghi d?ch v? m?i nh?t cho SQL Server 2012. ? bi?t thm chi ti?t, nh?p vo s? bi vi?t sau ? xem bi vi?t trong c s? ki?n th?c Microsoft:
2755533 Lm th? no ? c ?c gi b?n ghi d?ch v? m?i nh?t cho SQL Server 2012

T?nh tr?ng

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

Cch gi?i quy?t khc

? lm vi?c xung quanh v?n ? ny, t? thm cc b?c b? thi?u. C? th?, thm "ALTER DATABASE DatabaseName SET HADR AVAILBILLITY GROUP"l?nh cho m?i b? my c s? d? li?u s?n c v ?ng g?i th? c?p ?c xc ?nh trong nhm s?n c. V d?, b?n thm cc b?c sau:
-- On the server instance that hosts the secondary replica, 

-- join each secondary database to the availability group:

:Connect <<secondary replica 1>>

ALTER DATABASE MyDb1 SET HADR AVAILABILITY GROUP = MyAG;

GO

ALTER DATABASE MyDb2 SET HADR AVAILABILITY GROUP = MyAG;

GO

:Connect <<secondary replica 2>>

ALTER DATABASE MyDb1 SET HADR AVAILABILITY GROUP = MyAG;

GO

ALTER DATABASE MyDb2 SET HADR AVAILABILITY GROUP = MyAG;

GO

Thng tin thm

? bi?t thm chi ti?t v? lm th? no ? tham gia m?t b? my c s? d? li?u trung h?c m?t nhm s?n c, h?y vo web site MSDN sau y:
Lm th? no ? tham gia m?t b? my c s? d? li?u trung h?c m?t nhm s?n c
? bi?t thm chi ti?t v? cch s? d?ng thu?t s? s?n c Nhm M?i, h?y vo web site MSDN sau y:
Lm th? no ? s? d?ng thu?t s? s?n c Nhm M?i
? bi?t thm chi ti?t v? thu?t ng? ph?n m?m C?p Nh?t, b?m s? bi vi?t sau ? xem bi vi?t trong c s? ki?n th?c Microsoft:
824684 M t? cc thu?t ng? tiu chu?n ?c s? d?ng ? m t? C?p nh?t ph?n m?m Microsoft

Thu?c tnh

ID c?a bi: 2645920 - L?n xem xt sau cng: 20 Thang Chin 2012 - Xem xt l?i: 1.0
p d?ng
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Developer
T? kha:
kbqfe kbfix kbsurveynew kbexpertiseadvanced kbprb kbmt KB2645920 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: 2645920

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