Lm th? no ? sao lu Nh?t k? giao d?ch cu?i khi th?y v cc t?p tin b? my c s? d? li?u b? h h?ng trong SQL Server

D?ch tiu ? D?ch tiu ?
ID c?a bi: 253817 - 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

B?n c th? sao lu Nh?t k? giao d?ch hi?n ho?t ?ng ngay c? khi cc t?p tin b? my c s? d? li?u b? h h?ng, mi?n l cc t?p tin Nh?t k? giao d?ch l v?n c s?n. Trn Microsoft SQL Server 7.0, c? hai t?p tin d? li?u chnh v t?p nh?t k? giao d?ch ph?i c s?n ? b?n sao lu cc b?n ghi ho?t ?ng giao d?ch cu?i cng. N?u b? my c s? d? li?u t?ng th? c?ng b? h h?ng, b?n c th? xy d?ng l?i v khi ph?c l?i b? my c s? d? li?u ch? ?u tin, v sau sao lu cc b?n ghi ho?t ?ng giao d?ch cu?i cng c?a b? my c s? d? li?u khng c s?n. V d?, cc t?p tin d? li?u v thi?t b? t?ng th? c th? trn phng ti?n truy?n thng b? h h?ng. Tuy nhin, n?u ?ng g?i lu b? my c s? d? li?u t?ng th? khng c s?n, b?n c th? sao lu b?n ghi ho?t ?ng giao d?ch cu?i cng c?a b? my c s? d? li?u b?ng cch s? d?ng phng php ?c th?o lu?n trong bi vi?t ny, mi?n l cc t?p tin d? li?u chnh v t?p nh?t k? giao d?ch c s?n trn SQL Server 7.0.

Lu ? ? lm i?u ny trong Microsoft SQL Server 2000 ho?c trong Microsoft SQL Server 2005, ch? t?p nh?t k? giao d?ch ph?i c s?n.

Lu ? Cc ti?n ch xy d?ng l?i t?ng th? ?c th?c hi?n m?t cch khc nhau trong Microsoft SQL Server 2000 64 bit. Trong SQL Server 2000 64 bit, SQL Server m?t l?i th? c?a cc tnh nng t? s?a ch?a ?c cung c?p b?i Microsoft Windows ci ?t chuyn bi?t. Ngoi ra, ci ?t chuyn bi?t l?i b?t ?ng s?n v ti s?n REINSTALLMODE trn dong lnh thi?t l?p c s?n cho m?t cch r? rng xy d?ng l?i s? ki?m nh?p, ci ?t chuyn bi?t l?i cc t?p tin b? h?ng ho?c thi?u t?p tin, ci ?t chuyn bi?t l?i phim l?i tt b? h?ng ho?c thi?u cc phim l?i tt, v xy d?ng l?i b? my c s? d? li?u t?ng th? . Cc thu?c tnh ny c th? ?c xc ?nh trn dong lnh ho?c trong m?t t?p tin .ini.

sao lu Nh?t k? giao d?ch cu?i cng trong SQL Server 2000 ho?c SQL Server 2005

Trong SQL Server 2000 v SQL Server 2005, n?u b? my c s? d? li?u t?ng th? v cc t?p tin d? li?u c?a m?t b? my c s? d? li?u ng?i dng l x?u, nhng t?p nh?t k? giao d?ch c?a b? my c s? d? li?u l v?n c?n c s?n, b?n v?n c th? sao lu cc b?n ghi ho?t ?ng giao d?ch cu?i cng c?a b? my c s? d? li?u ? gi?m m?t mt d? li?u. N?u b? my c s? d? li?u t?ng th? khng ph?i l x?u, xem ch? ? "Sao lu Nh?t k?" trong SQL Server sch tr?c tuy?n.

? sao lu Nh?t k? giao d?ch cu?i cng trong SQL Server 2000 ho?c SQL Server 2005, h?y lm theo cc b?c sau:
  1. ?i tn t?p nh?t k? giao d?ch.
  2. Xy d?ng l?i b? my c s? d? li?u t?ng th? .
  3. T?o m?t b? my c s? d? li?u tng t?. b? my c s? d? li?u m?i no khng ph?i l cng kch th?c; Tuy nhin, n ph?i c cng s? l?ng d? li?u v t?p tin ghi lu.
  4. D?ng SQL Server 2000 ho?c SQL Server 2005.
  5. Xa t?t c? cc t?p tin d? li?u c?a sothat b? my c s? d? li?u m?i ?c t?o ra, n s? khng thnh cng ph?c h?i. Thay th? cc t?p tin k nh?p c?a b? my c s? d? li?u m?i v?i theoriginal k nh?p t?p tin ? b?n c th? sao lu Nh?t k? giao d?ch.
  6. Kh?i ?ng l?i SQL Server 2000 ho?c SQL Server 2005.
  7. Ch?y l?nh ny ? tr? l?i ui c?a Nh?t k?:
    Backup Log <database_name> to Disk = <device_name> With NO_TRUNCATE
  8. S? d?ng cc sp_dbremove lu tr? th? t?c ? lo?i b? b? my c s? d? li?u.

sao lu Nh?t k? giao d?ch cu?i cng trong SQL Server 7.0

? sao lu cc ho?t ?ng giao d?ch cu?i k nh?p trong SQL Server 7.0, h?y lm theo cc b?c sau:
  1. ?i tn cc d? li?u chnh t?p tin v giao d?ch t?p tin ghi lu.
  2. Xy d?ng l?i b? my c s? d? li?u t?ng th? .
  3. T?o m?t b? my c s? d? li?u tng t?. b? my c s? d? li?u m?i no khng ph?i l cng kch th?c; Tuy nhin, n ph?i c cng s? l?ng d? li?u v t?p tin ghi lu.
  4. D?ng SQL Server 7.0.
  5. Xa t?t c? cc t?p tin d? li?u c?a sothat b? my c s? d? li?u m?i ?c t?o ra, n s? khng thnh cng ph?c h?i. Thay th? t?p d? li?u chnh v k nh?p cc t?p tin c?a b? my c s? d? li?u m?i v?i m?t b?n g?c ? b?n c th? sao lu transactionlog.
  6. Kh?i ?ng l?i SQL Server 7.0.
  7. Ch?y l?nh ny ? tr? l?i ui c?a Nh?t k?:
    Backup Log <database_name> to Disk = <device_name> With NO_TRUNCATE
  8. S? d?ng cc sp_dbremove lu tr? th? t?c ? lo?i b? b? my c s? d? li?u.
  9. Khi ph?c l?i b? my c s? d? li?u v?i t?t c? cc t?p tin log.

Thu?c tnh

ID c?a bi: 253817 - L?n xem xt sau cng: 03 Thang Ba 2014 - Xem xt l?i: 3.0
p d?ng
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2000 64-bit Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Workgroup Edition
T? kha:
kbhowtomaster kbmt KB253817 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: 253817

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