b? my c s? d? li?u SQL Server khng ?c h? tr? trn nn t?p

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

Tm t?t

Microsoft b? my c s? d? li?u SQL Server khng ?c h? tr? trn NTFS ho?c FAT nn t?p. M?t kh?i l?ng nn khng ?m b?o lin k?t khu v?c vi?t c?n thi?t ? ?m b?o ph?c h?i giao d?ch trong m?t s? tr?ng h?p.

Thng tin thm

M?c d n l v?t l? c th? thm vo b? my c s? d? li?u SQL Server trn nn t?p, chng ti khng khuyn b?n nn n, v chng ti khng h? tr? n. Nh?ng l? do ti?m ?n ny bao g?m:
  • Hi?u su?t

    b? my c s? d? li?u vo kh?i l?ng nn c th? gy ra hi?u su?t ng k? chi ph. S? ti?n s? khc nhau, ty thu?c vo kh?i l?ng i/o: v trn t? l? c?a l?n ?c ? vi?t. Tuy nhin, trong suy thoi ph?n trm 500 ?c quan st th?y trong m?t s? i?u ki?n.
  • b? my c s? d? li?u ph?c h?i

    ng tin c?y giao d?ch ph?c h?i b? my c s? d? li?u yu c?u lin k?t khu v?c kinh t? vi?t, v nn t?p khng h? tr? k?ch b?n ny. M?t v?n ? th? hai m?i quan tm qu?n l? khng gian bn trong ph?c h?i. SQL Server trong n?i b? c preallocated khng gian trong t?p tin b? my c s? d? li?u ? rollbacks. C th? ngy nn t?p ? nh?n ?c m?t l?i "Out of Space" trn cc t?p tin preallocated, v interfers ny v?i ph?c h?i thnh cng.
Trong cc t?nh hu?ng nh?t ?nh, m?t sao lu SQL Server khng ph?i l thnh cng ? m?t kh?i l?ng nn ho?c nn c?p. Khi v?n ? ny x?y ra, b?n nh?n ?c m?t thng bo l?i sau y.

Windows Vista v phin b?n m?i nh?t c?a Windows

STATUS_FILE_SYSTEM_LIMITATION thao tc ?c yu c?u khng th? hon t?t do gi?i h?n m?t h? th?ng t?p

h iu hanh l?i 665 (thao tc yu c?u c th? khng th? hon t?t do gi?i h?n m?t h? th?ng t?p tin)
Trn phin b?n tr?c c?a Windows

Ti nguyn h? th?ng khng ? STATUS_INSUFFICIENT_RESOURCES t?n t?i ? hon thnh cc b?n ghi d?ch v? ?c yu c?u

i?u hnh h? th?ng l?i 1450 (khng ? h? ti nguyn t?n t?i ? hon thnh cc yu c?u ho?c 33 (qu tr?nh khng th? truy nh?p t?p v? m?t ti?n tr?nh ? kha m?t ph?n c?a t?p tin.)
? bi?t thm thng tin v? v?n ? ny, xem bi vi?t sau trong c s? ki?n th?c Microsoft:
967351 M?t t?p tin phn m?nh n?ng n? trong m?t kh?i l?ng NTFS c th? pht tri?n khng v?t qu m?t kch th?c nh?t ?nh
Ghi ch
  • Hotfix cho Windows Vista v phin b?n m?i nh?t c?a Windows th?o lu?n trong bi KB 967351 c th? gi?i quy?t v?n ? c?a ?ng g?i lu SQL Server m khng ph?i l thnh cng ? m?t kh?i l?ng nn ho?c vo m?t c?p nn. Tuy nhin, hotfix ny s? gip vi?c dn x?p cc v?n ?.
  • Sau khi b?n p d?ng hotfix ?c th?o lu?n trong bi KB 967351, b?n ph?i ?nh d?ng ia m nn ?c kch ho?t b?ng cch s? d?ng tham s?/l . Khi b?n ?nh d?ng ia m nn ?c kch ho?t b?ng cch s? d?ng tham s?/l , byte cho m?i File Records o?n tng t? 1.024 byte ?n 4,096 byte.
sao lu SQL Server ? nn t?p ? y c th? ti?t ki?m kho?ng tr?ng ?a. Tuy nhin, h? c th? lm tng vi?c s? d?ng CPU trong thao tc sao lu. Chng ti lun lun khuyn r?ng b?n s? d?ng cc c s? ki?m tra sao lu ? gip ?m b?o tnh ton v?n d? li?u.

? bi?t thm chi ti?t v? cc lo?i tr? ch? ?c b? my c s? d? li?u v cho t?p ch?-?c nhm trong SQL Server 2005, gh thm Web site sau c?a Microsoft pht tri?n m?ng (MSDN):
http://MSDN.Microsoft.com/en-US/Library/ms190257 (SQL.90) .aspx
? bi?t thm thng tin v? lo?i tr? ch? ?c b? my c s? d? li?u v cho t?p ch?-?c nhm trong SQL Server 2008, truy c?p MSDN Web site sau:
http://MSDN.Microsoft.com/en-US/Library/ms190257.aspx
SQL Server yu c?u h? th?ng h? tr? 'b?o ?m giao hng ? phng ti?n truy?n thng ?n ?nh' nh ?c nu trong chng tr?nh Microsoft SQL Server Always-On lu tr? gi?i php xem xt. ? bi?t thm chi ti?t v? cc yu c?u ?u vo v ?u ra cho b? my c s? d? li?u SQL Server, nh?p vo s? bi vi?t sau ? xem bi vi?t trong c s? ki?n th?c Microsoft:
967576Microsoft SQL Server b? my c s? d? li?u cng c? ?u vo/?u ra yu c?u

Thu?c tnh

ID c?a bi: 231347 - L?n xem xt sau cng: 20 Thang Bay 2012 - Xem xt l?i: 3.0
p d?ng
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2000 Developer Edition
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Personal Edition
  • Microsoft SQL Server 2000 Workgroup Edition
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 6.5 Standard Edition
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Standard
T? kha:
kbsurveynew kbexpertiseadvanced kbsql2005setup kbinfo kbmt KB231347 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: 231347

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