Lm th? no ? tng s? l?ng cc b?n ghi l?i SQL Server

D?ch tiu ? D?ch tiu ?
ID c?a bi: 196909 - 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? lm th? no ? tng s? l?ng cc b?n ghi l?i SQL Server.

theo m?c ?nh, cc b?n ghi l?i SQL Server ?c lu gi? trong m?c tin th thoai con k nh?p c?a my ch? SQL. theo m?c ?nh, c b?y cc b?n ghi l?i SQL Server; ERRORLOG v Errorlog.1 qua Errorlog.6. tn ng nhp hi?n t?i, g?n y nh?t l Errorlog v?i ph?n m? r?ng khng. Cc b?n ghi l?i ?c t?o ra m?i khi b?n kh?i ?ng l?i SQL Server. Khi cc t?p tin Errorlog l ti t?o ra, k nh?p tr?c ?c ?i tn thnh Errorlog.1, v k nh?p tr?c ti?p theo (Errorlog.1) ?c ?i tn thnh Errorlog.2, v nh v?y. ERRORLOG.6 s? b? xa. i?u ny th?c s? x?y ra theo th? t? ng?c, nhng k?t qu? l nh nhau.

Trong m?t s? tr?ng h?p, b?n c th? mu?n gi? cho hn b?y b?n ghi lu tr?. Trong SQL Server 2000 v phin b?n m?i hn, s? l?ng cc b?n ghi l?i ?c t?o ra tr?c khi chng ?c ti ch? l c?u h?nh thng qua menu context-sensitive popup cho Nh?t k? my ch? SQL. ? bi?t thm chi ti?t, tham kh?o ? ki?n ch? ? sau trong SQL Server sch tr?c tuy?n:
?t c?u h?nh b?n ghi l?i SQL Server
Trong SQL Server 7.0, b?n c th? thm m?t ki?m nh?p thi?t l?p quan tr?ng ? gi? l?i b?n ghi l?i nhi?u hn b?y.

Tng cc s? c?a SQL my ch? b?n ghi l?i trong SQL Server 7.0 mi tr?ng

C?nh bo: n?u b?n s? d?ng Registry Editor khng chnh xc, b?n c th? gy ra v?n ? nghim tr?ng m c th? yu c?u b?n ph?i ci ?t chuyn bi?t l?i h iu hanh. Microsoft khng th? ?m b?o r?ng b?n c th? gi?i quy?t v?n ? m k?t qu? t? vi?c s? d?ng Registry Editor khng chnh xc. S? d?ng tr?nh so?n th?o Registry nguy c c?a ring b?n.

V? l?nh ny thay ?i s? ki?m nh?p, Microsoft khuy?n co b?n sao lu cc thay ?i. B?n c th? lm i?u ny b?ng cch ch?y dong lnh ti?n ch Regrebld.exe v?i cc -sao lu tham s?. V d?:
D:\MSSQL7\BINN>regrebld -Backup
Lu ?: Ti?n ch dong lnh Regrebld.exe l ch? c s?n trong SQL Server 7.0. ? bi?t thng tin v? lm th? no ? xy d?ng l?i s? ki?m nh?p trong SQL Server 2000, xem SQL Server sch tr?c tuy?n.

L?nh ny t?o ra nm t?p tin trong m?c tin th thoai con Binn SQL Server:
  • Mssql7.rbk
  • Mssql7ct.rbk
  • Mssql7ea.rbk
  • Mssql7es.rbk
  • Mssql7p.rbk
Lu nh?ng t?p tin ny b?i v? b?n c?n h? ? khi ph?c s? ki?m nh?p.

Kho ki?m nh?p m?i m b?n c th? thi?t l?p l:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\NumErrorLogs
theo m?c ?nh, ch?a kha ny l v?ng m?t. Gi tr? l lo?i REG_DWORD. S?a ?i cc gi tr? cho s? l?ng cc b?n ghi m b?n mu?n ? duy tr?.

Ngoi ra, trong SQL Server 7.0, b?n c th? chu k? logwithout l?i kh?i ?ng l?i SQL Server b?ng cch ch?y th? t?c sp_cycle_errorlog lu tr?. Th? t?c ny l m?t wrapper n gi?n cho cc bo co DBCC ERRORLOG. Ch?y DBCC ERRORLOG ?t l?i Nh?t k? l?i SQL Server.

Tham kh?o

? bi?t thm thng tin v? vi?c tng s? SQL Server, archiveable nh?t k l?i cc phin b?n c? hn c?a SQL Server, nh?p vo s? bi vi?t sau ? xem bi vi?t trong c s? ki?n th?c Microsoft:
230590 Lm th? no ? lu tr? nhi?u hn su b?n ghi l?i SQL Server

Thu?c tnh

ID c?a bi: 196909 - L?n xem xt sau cng: 09 Thang Nm 2014 - Xem xt l?i: 3.0
p d?ng
  • Microsoft SQL Server 2000 Developer Edition
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Personal Edition
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Workgroup
  • 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 Workgroup
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2014 Developer
  • Microsoft SQL Server 2014 Enterprise
  • Microsoft SQL Server 2014 Standard
T? kha:
kbhowtomaster kbmt KB196909 KbMtvi
My d?ch
QUAN TRONG: Bai vit nay c d?ch b?ng phn mm dich thu?t cua Microsoft va co th c Cng ng Microsoft chinh sa l?i thng qua cng ngh CTF thay vi mt bin dich vin chuyn nghip. Microsoft cung c?p cc bi vi?t ?c c? bin d?ch vin v ph?n m?m d?ch thu?t th?c hi?n v c?ng ?ng ch?nh s?a l?i ? 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 nhi?u ngn ng? Tuy nhin, bi vi?t do my d?ch hoc thm chi cng ng chinh sa sau khng ph?i lc no c?ng hon h?o. Cc bi vi?t ny c th? ch?a cc sai st v? t? v?ng, c php ho?c ng? php, 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.
Nh?p chu?t vo y ? xem b?n ti?ng Anh c?a bi vi?t ny: 196909

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