Chi?n d?ch Ntbackup.exe c th? ph v? cc chu?i sao lu vi phn c?a b? my c s? d? li?u SQL Server v c th? lm m?t hi?u l?c cc ?ng g?i lu khc bi?t khi b?n th?c hi?n m?t b?n ch?p sao lu b? m...

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

GI?I THI?U

Lu ?Bi vi?t ny th?o lu?n v? Ntbackup.exe. Tuy nhin, bi vi?t ny p d?ng cho t?t c? cc s?n ph?m s? d?ng cc ?o thi?t b? giao di?n (VDI), bao g?m SQL Server.

Cc ti?n ch Ntbackup.exe s? d?ng VDI ? th?c hi?n m?t b?n ch?p sao lu b? my c s? d? li?u Microsoft SQL Server. Khi b?n s? d?ng ti?n ch ny, cc ho?t ?ng c th? ph v? cc chu?i sao lu vi phn c?a b? my c s? d? li?u SQL Server v lm m?t hi?u l?c cc ?ng g?i lu khc bi?t.B?n c th? th?y thng bo l?i sau y khi b?n c? g?ng t?o ra m?t ?ng g?i lu khc bi?t:

Msg 3035, c?p 16, bang 1, d?ng 1
Khng th? th?c hi?n m?t sao lu vi sai ?i v?i b? my c s? d? li?u "NTBackupTest", b?i v? m?t ?ng g?i lu b? my c s? d? li?u hi?n nay khng t?n t?i. Th?c hi?n m?t sao lu b? my c s? d? li?u ?y ? b?ng ph?c sao lu b? my c s? d? li?u, b? qua cc ty ch?n khc v?i bi?t.
Msg 3013, c?p 16, bang 1, d?ng 1
sao lu b? my c s? d? li?u ch?m d?t b?t th?ng



Thng tin thm

ngi quan tri h thng c th? s? d?ng ti?n ch Ntbackup.exe trong Windows Server 2003 ? sao lu b? my c s? d? li?u SQL Server khi SQL my ch? ang ch?y. Khi Ti?n ch Ntbackup.exe B?t ?u qu tr?nh sao lu, cc hnh vi sau y x?y ra:
  • SQL Server m? t?p tin b? my c s? d? li?u trong ch? ? ?c quy?n.
  • SQL Server ngn ch?n qu tr?nh khc t? ?c t?p tin b? my c s? d? li?u ngay c? khi cc t?p tin ang ?c s? d?ng.
Trong Windows Server 2003, thay ?i ? ?c th?c hi?n ? ti?n ch Ntbackup.exe. Nh?ng thay ?i ny cho php b?n th?c hi?n m?t VDI ?nh ch?p sao lu b? my c s? d? li?u SQL Server. Sau khi thnh cng ch?y ti?n ch Ntbackup.exe, thng bo sau ?c ghi vo Nh?t k? l?i SQL Server:
2005-03-07 12:53:14.17 spid54 b? my c s? d? li?u msdb: IO l ng l?nh cho ?nh ch?p
Ngy Th?i gian spid52 b? my c s? d? li?u Northwind: IO l ng l?nh cho ?nh ch?p
Ngy Th?i gian spid53 b? my c s? d? li?u qun r?u: IO l ng l?nh cho ?nh ch?p
Ngy Th?i gian spid55 b? my c s? d? li?u m?u: IO l ng l?nh cho ?nh ch?p
Ngy Th?i gian b? my c s? d? li?u spid51 Th?c s?: IO l ng l?nh cho ?nh ch?p
Ngy Th?i gian spid51 b? my c s? d? li?u t?ng th?: IO tan
Ngy Th?i gian b? my c s? d? li?u spid52 Northwind: IO tan
Ngy Th?i gian spid53 b? my c s? d? li?u qun r?u: IO tan
Ngy Th?i gian spid54 b? my c s? d? li?u msdb: IO tan
Ngy Th?i gian spid55 b? my c s? d? li?u m?u: IO tan
Ngy Th?i gian b? my c s? d? li?u sao lu sao lu: c s? d? li?u: m h?nh, sng t?o Date(Time): 2000/08/06(01:40:52), trang ?: 1, LSN ?u tin: 5:268:1, cu?i cng LSN: 5:272:1, s? l?ng cc thi?t b? ?: 1, thi?t b? thng tin: (FILE = 1, LO?I = VIRTUAL_DEVICE: {'{3805AE94-9393-4E93-9DCD-292771DA7239} 2'}).
2005-03-07 12:53:16.72 sao lu b? my c s? d? li?u sao lu: c s? d? li?u: Northwind, sng t?o date(time): 2000/08/06(01:41:00), trang ?: 1, ?u tin LSN: 25:156:1, cu?i LSN: 25:160:1, s? l?ng cc b?i ch?a thi?t b?: 1, thi?t b? thng tin: (FILE = 1, LO?I = VIRTUAL_DEVICE: {'{3805AE94-9393-4E93-9DCD-292771DA7239} 5'}).
2005-03-07 12:53:16.72 sao lu b? my c s? d? li?u sao lu: c s? d? li?u: qun r?u, sng t?o Date(Time): 2000/08/06(01:40:58), trang ?: 1, LSN ?u tin: 5:192:1, cu?i cng LSN: 5:196:1, s? l?ng cc thi?t b? ?: 1, thi?t b? thng tin: (FILE = 1, LO?I = VIRTUAL_DEVICE: {'{3805AE94-9393-4E93-9DCD-292771DA7239} 4'}).
2005-03-07 12:53:16.89 sao lu b? my c s? d? li?u sao lu: c s? d? li?u: Th?c s?, sng t?o date(time): 2005/03/07(12:47:00), trang ?: 1, ?u tin LSN: 180:42:1, cu?i LSN: 180:46:1, s? l?ng cc b?i ch?a thi?t b?: 1, thi?t b? thng tin: (FILE = 1, LO?I = VIRTUAL_DEVICE: {'{3805AE94-9393-4E93-9DCD-292771DA7239} 1'}).
2005-03-07 12:53:16.89 sao lu b? my c s? d? li?u sao lu: c s? d? li?u: msdb, sng t?o Date(Time): 2000/08/06(01:40:56), trang ?: 1, LSN ?u tin: 92:370:1, cu?i cng LSN: 92:374:1, s? l?ng cc thi?t b? ?: 1, thi?t b? thng tin: (FILE = 1, LO?I = VIRTUAL_DEVICE: {'{3805AE94-9393-4E93-9DCD-292771DA7239} 3'}).
Tr?c khi hotfix 828481, Ti?n ch Ntbackup.exe ? khng tr? l?i ln SQL Server b? my c s? d? li?u n?u b?t k? b? my c s? d? li?u ng?i dng s? d?ng cc m h?nh b? my c s? d? li?u ph?c h?i ?y ?. Cc ti?n ch Ntbackup.exe ch? lm vi?c khi ng?i dng t?t c? b? my c s? d? li?u s? d?ng cc m h?nh b? my c s? d? li?u ph?c h?i n gi?n.

Hotfix 828481 l?n Ti?n ch Ntbackup.exe ? cho php qu tr?nh sao lu b? my c s? d? li?u SQL Server c?ng s? d?ng cc m h?nh ph?c h?i.


Tham kh?o

? 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:
828481L?i 800423f4 xu?t hi?n trong cc t?p tin sao lu k nh?p khi b?n tr? l?i ln m?t kh?i l?ng b?ng cch s? d?ng cc b?n ghi d?ch v? ?ng g?i bng kh?i l?ng trong Windows Server 2003

Thu?c tnh

ID c?a bi: 903643 - L?n xem xt sau cng: 27 Thang Hai 2013 - Xem xt l?i: 1.0
p d?ng
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Personal Edition
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2000 Workgroup Edition
  • Microsoft SQL Server 2000 Developer Edition
  • Microsoft Windows Server 2003, Datacenter Edition (32-bit x86)
  • Microsoft Windows Server 2003, Enterprise Edition (32-bit x86)
  • Microsoft Windows Server 2003, Enterprise Edition for Itanium-based Systems
  • Microsoft Windows Server 2003, Standard Edition (32-bit x86)
  • Microsoft Windows Server 2003, Web Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Enterprise Evaluation
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Standard
T? kha:
kbtshoot kbinfo kbmt KB903643 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: 903643

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