Cc ngu?n ti nguyn tn m?ng SQL Server khng th? ?c ?i tn thnh

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

TRI?U CH?NG

Nhm ng?i qu?n tr? cung c?p m?t phng php ? ?i tn c?m ti nguyn. ? lm i?u ny, b?m chu?t ph?i vo cc ngu?n ti nguyn trong c?m sao qu?n tr? vin, v sau b?m ?i tn.

Tuy nhin, vi?c ?i tn my ch? SQL my ch? ?o, ho?c t?p h?p, khng ?c h? tr? trong phin b?n hi?n t?i c?a Microsoft SQL H? ph?c v?. N?u b?n ?i tn cc ngu?n ti nguyn tn m?ng SQL Server, m?t lo?t cc v?n ? c th? x?y ra. M?t trong nh?ng v?n ? c th? x?y ra l SQL Server ?o tr?ng h?p my ch? c th? khng c?n ?n tr?c tuy?n. Khi v?n ? ny x?y ra, cc thng tin sau c th? ?c ng trong s? ghi s? ki?n ?ng d?ng:
MSSQLSERVER l?i (3) 17052 n/A BOPDEV1 [sqsrvres] checkODBCConnectError: sqlstate = 08001; b?n x? l?i = 11; tin nh?n = [Microsoft] [ODBC SQL Server Driver] [DBNETLIB] SQL Server khng t?n t?i ho?c truy nh?p b? c?m.
MSSQLSERVER l?i (3) 17052 n/A BOPDEV1 [sqsrvres] ODBC sqldriverconnect th?t b?i

GI?I PHP

M?t cch chnh xc ? ?i tn m?t t?p h?p SQL Server 2000 my ch? ?o l ? lo?i b? v sau ci ?t l?i SQL Server 2000 b?ng cch s? d?ng tn my ch? ?o m?i. Hnh vi ny l do thi?t k?.

Lu ? Tr?c khi b?n lo?i b? SQL Server 2000, ?m b?o r?ng b?n ? sao l?p c s? d? li?u, bao g?m c? cc Th?c s? c s? d? li?u. Sau b?n c th? khi ph?c l?i cc c s? d? li?u sau khi b?n ci ?t l?i my ch? SQL.

B?n c?ng c th? ?i tn g?c hi?n c c?a b?n c s? d? li?u th m?c \Data ?n m?t tn m l tng t? nh \DataSave. C?p ny l th?ng ? v? tr sau:
%Drive%\Program Files\Microsoft SQL Server\MSSQL\Data
? xc nh?n v? tr, h?y lm theo cc b?c sau:
  1. B?t ?u qu?n l? SQL my ch? doanh nghi?p.
  2. Nh?p chu?t ph?i th? hi?n c?a SQL Server m b?n mu?n ? lo?i b?, v sau nh?p vo Thu?c tnh.
  3. B?m vo cc T?ng qut tab.
  4. Nh?p vo Tham s? kh?i ?ng.

    V? tr c s? d? li?u ?c li?t k v?i m?c d (v d?: -dC:\Program Files\Microsoft SQL Server\MSSQL\Data\master.mdf)
Thm vo vi?c ?i tn th m?c \Data c?a b?n, b?n c th? lm cho m?t ring bi?t sao c?p ny v dn n ? m?t v? tr trn ? ?a.

? bi?t thm chi ti?t, b?m vo s? bi vi?t sau y ? xem bi vi?t trong cc ki?n th?c Microsoft C s?:
224071Di chuy?n c s? d? li?u SQL Server ?n m?t ?a i?m m?i v?i Detach/nh km

Thu?c tnh

ID c?a bi: 307336 - L?n xem xt sau cng: 27 Thang Tam 2011 - Xem xt l?i: 2.0
p d?ng
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Developer Edition
T? kha:
kbhowto kbclustering kbinfo kbmt KB307336 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:307336

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