Lm th? no ? xy d?ng l?i c s? d? li?u ch? vo m?t tr?ng h?p SQL Server ?o

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

? Trang ny

TM T?T

Bi vi?t ny m t? cc b?c b?n ph?i th?c hi?n ? xy d?ng l?i m?t Th?c s? c s? d? li?u vo m?t v d? ?o (Clustered) SQL Server.

THNG TIN THM

Lm th? no ? xy d?ng l?i c s? d? li?u ch? vo m?t ?o (nhm) SQL Server 2000 Server

? xy d?ng l?i cc Th?c s? SQL Server 2000 c s? d? li?u, th?c hi?n theo cc b?c sau:
  1. ?m b?o r?ng my ch? SQL ti nguyn ang ki?m sot b?i nt m b?n th?c hi?n Rebuildm.exe.
  2. Mang l?i cho my ch? SQL virtual server gin tuy?n b?ng cch s? d?ng cc SQL Server d?ch v? qu?n l?.
  3. ?m b?o r?ng cc b?n g?c chia s? t?p tin ci ?t ho?c ?a CD ci ?t SQL Server c s?n.

    N?u b?n s? d?ng SQL ?a CD ci ?t my ch?, sao chp t?t c? cc t?p tin t? ?a CD vo m?t ?a c?ng c?c b?. Lo?i b? cc thu?c tnh ch? ?c t? cc t?p tin sau khi b?n sao h? ?n cc kh khn ? ?a. ? bi?t thm chi ti?t, h?y tham kh?o bi vi?t sau y trong Microsoft Ki?n th?c c b?n:
    273572 L?I: Rebuildm.exe Utility i?m d?ng p ?ng khi Source Directory l trn ?a CD
  4. Th?c thi Rebuildm.exe v i?m n ?:
    • Ci ?t chia s? t?p g?c.

      - hay -
    • Cc t?p tin m b?n ? sao t? ?a CD ? cc ?a phng c?ng ? ?a.
  5. Ch?n Windows Collation, ho?c SQL Collation.
  6. Sau khi hon t?t chng tr?nh Rebuildm.exe, xc minh r?ng b?n c th? mang l?i cho cc ngu?n ti nguyn tr?c tuy?n v h? thnh cng khng qua.
  7. Th?c thi cc sp_helpsort th? t?c ?c lu tr? ? xc minh collation.
LU ?: Cc b?c tr?c khng bao g?m cc b?c l c?n thi?t ? xy d?ng l?i c s? d? li?u ng?i dng. N?u b?n c m?t b?n sao lu g?n y c?a cc Th?c s? c s? d? li?u, b?n c th? khi ph?c n vo th?i i?m ny. N?u khng, b?n ph?i Khi ph?c ho?c nh km cc c s? d? li?u ng?i dng.

B?n ph?i kh?i ?ng SQL Server t? m?t d?u nh?c l?nh vo nt ho?t ?ng ? k?t n?i v khi ph?c.

Chu y Trong SQL Server 2005, t?p tin Rebuildm.exe ? b? ngng. ? xy d?ng l?i cc Th?c s? c s? d? li?u, s? d?ng cc t?p tin Setup.exe.

THAM KH?O

SQL Server 2000 sch tr?c tuy?n; ch? ?: "xy d?ng l?i Master C s? d? li?u"

Thu?c tnh

ID c?a bi: 298568 - 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
  • Microsoft SQL Server 2000 Developer Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
T? kha:
kbinfo kbmt KB298568 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:298568

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