Thi?t b? m?t tch nguyn nhn c s? d? li?u ph?i ?c nh d?u nghi ng?

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


SQL Server nh d?u m?t nghi ng? c s? d? li?u n?u b?t k? t?p tin thi?t b? cho cc c s? d? li?u khng s?n dng khi n c? g?ng ? b?t ?u. B?n c th? th?y m?t trong cc t?p sau c?a tin nh?n trong Nh?t k? l?i SQL Server:
Thng bao li 1
96/11/18 10:48:32.60 h?t nhn udopen: h? i?u hnh l?i 32 (The
qu tr?nh khng th? truy nh?p t?p v? n ang ?c s? d?ng c?a ng?i khc
qu tr?nh.) trong vi?c sng t?o/m? thi?t b? v?t l?,

96/11/18 10:48:32.60 h?t nhn udactivate (ti?u): th?t b?i trong vi?c m?
thi?t b? C:\MSSQL\DATA\MSDB.DAT (ho?c C:\DATA\SQL\MSDB.MDF) cho vdn 127
Thng bo l?i 2
96/11/18 10:48:32.60 h?t nhn udopen: h? i?u hnh l?i 2 (The
h? th?ng khng t?m th?y t?p ?c ch? ra.) trong th?i gian sng t?o/m?
thi?t b? v?t l? C:\MSSQL\DATA\MSDB.DAT (ho?c C:\DATA\SQL\MSDB.MDF)

96/11/18 10:48:32.60 h?t nhn udactivate (ti?u): th?t b?i trong vi?c m? thi?t b? C:\MSSQL\DATA\MSDB.DAT (ho?c C:\DATA\SQL\MSDB.MDF) cho vdn 127
y s? ?c theo sau trong Nh?t k? b?i:
96/11/18 10:48:36.70 h?t nhn udread: h? i?u hnh l?i 6 (The
i?u tc khng h?p l?.) trn thi?t b? ' C:\MSSQL\DATA\MSDB.DAT' (ho?c C:\DATA\SQL\MSDB.MDF) (virtpage

96/11/18 10:48:36.77 spid11 Error: 840, m?c ? nghim tr?ng: 17, bang: 2

96/11/18 10:48:36.77 spid11 thi?t b? 'MSDBData' (v?i th? ch?t tn
' C:\MSSQL\DATA\MSDB.DAT' (ho?c C:\DATA\SQL\MSDB.MDF), v s? thi?t b? ?o 127) l khng
c s?n. Xin vui l?ng lin h? v?i ng?i qu?n tr? h? th?ng ? ?c tr? gip.

96/11/18 10:48:36.77 spid11 ?m 1092480 t? c s? d? li?u 'msdb'
c s? trang 0 trong tiu ? trang v trang s? 24 trong cc
tiu ? b? ?m

96/11/18 10:48:37.43 spid11 khng th? ti?n hnh v?i vi?c thu h?i
dbid <5> v? c?a l?i tr?c . Ti?p t?c v?i k? ti?p</5>
c s? d? li?u.
V d?, th?c hi?n cc b?c sau y s? ch?ng minh v?n ?:
  1. Ngn ch?n SQL Server.
  2. Pht hnh l?nh sau y t? m?t d?u nh?c l?nh v Mssql\Data th m?c:

    ren msdb.dat msdb.sav
  3. B?t ?u my ch? SQL.
B?n s? th?y nh?ng l?i ? trn (nh?ng t? t?p th? hai) trong SQL H? ph?c v? errorlog. N?u b?n sau pht hnh truy v?n sau y trong master c s? d? li?u
   select name, dbid, mode, status from sysdatabases where dbid =

B?n nh?n ?c cc k?t qu? sau:
   name     dbid   mode   status
   msdb      5      0      328

T?nh tr?ng c?a 328 nh gi:
   truncate log on chkpt
   database not recovered yet
   database is suspect

? bi?t thm chi ti?t, xem cc ch? ? "Sysdatabases (Master Database ch?)" trong SQL Server sch tr?c tuy?n.


Lc kh?i ?ng, SQL Server c? g?ng ? c ?c m?t kha ?c quy?n trn thi?t b? t?p tin. N?u thi?t b? ang ?c s? d?ng b?i m?t ti?n tr?nh khc (v d?, sao lu ph?n m?m) ho?c n?u t?p b? thi?u, cc k?ch b?n m t? ? trn s? g?p ph?i. Trong nh?ng tr?ng h?p ny, c th?ng l khng c g? sai v?i cc cc thi?t b? v c s? d? li?u. ?i v?i c s? d? li?u ph?c h?i m?t cch chnh xc, thi?t b? ph?i ?c th?c hi?n c s?n, v t?nh tr?ng c s? d? li?u ph?i ?c ?t l?i.


? lm vi?c xung quanh v?n ? ny, th?c hi?n cc b?c d?i y. Lu ? r?ng cc b?c cu?i cng l r?t quan tr?ng.
  1. ?m b?o r?ng cc t?p tin thi?t b? l th?c s? s?n sng.
  2. S? d?ng cc th? t?c ?c lu tr? b? sung sp_resetstatus ? thi?t l?p l?i t?nh tr?ng m?t c s? d? li?u nghi ng?. N?u b?n khng lm nh v?y, t?o ra i?u ny th? t?c b?i th?c hi?n cc t?p l?nh Instsupl.sql, t?m th?y trong cc Mssql\Install th m?c. ? bi?t thm chi ti?t v? sp_resetstatus, xem cc "?t l?i cho r?ng t?nh tr?ng" ch? ? trong SQL Server sch Online.
  3. Th?c hi?n sp_resetstatus trong c s? d? li?u t?ng th? cho c s? d? li?u nghi ng?:
          use master
          exec sp_resetstatus msdb   -- replace msdb with your database name
    B?n s? th?y ?u ra sau y:
          Prior to Update sysdatabases attempt for DBName='msdb', the mode=0
          and status=328 (status suspect_bit=256). For DBName='msdb' in
          sysdatabases, status bit 256 was forced Off and mode was forced to
          0. WARNING: You MUST stop/restart SQL Server prior to accessing this
  4. Ng?ng v kh?i ?ng l?i my ch? SQL.
  5. Xc minh r?ng c s? d? li?u ? ?c thu h?i v c s?n.


N?u c s? d? li?u v?n ?c nh d?u l nghi ng? sau khi th?c hi?n cc b?c ny, c th? c cc v?n ? khc ngn ch?n c s? d? li?u ph?c h?i. T?i th?i i?m ny, b?n c th? khi ph?c t? b?n sao lu t?t ho?c ?t c s? d? li?u ch? ? kh?n c?p v s? d?ng s? l?ng l?n b?n sao chng tr?nh (BCP) v?i s? l?ng l?n sao chp d? li?u ra. ? bi?t thm thng tin, h?y b?m vao s? bi vi?t sau ? xem bi vi?t trong C s? Ki?n th?c Microsoft:
165918B? qua ch? ? (tr?ng h?p kh?n c?p) v b?i ch?a giao d?ch v?i NO_LOG
Quan tr?ng N?u b?n s? d?ng bi vi?t ny (Q165918) v khng ch?c ch?n c?a ?y ? h?u qu? c?a b?t k? hnh ?ng m b?n ang th?c hi?n, lin h? v?i ti?u h?c c?a b?n h? tr? nh cung c?p ? ?c h? tr?.

Thu?c tnh

ID c?a bi: 180500 - L?n xem xt sau cng: 01 Thang Chin 2011 - Xem xt l?i: 3.0
p d?ng
  • Microsoft SQL Server 6.0 Standard Edition
  • Microsoft SQL Server 6.5 Standard Edition
T? kha:
kbprb kbmt KB180500 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:180500
Khc t Ni dung trong C s Kin thc Khng con c h tr
Bi vi?t ny ni v? cc s?n ph?m m Microsoft khng c?n h? tr? n?a. Do , bi vi?t ny ?c cung c?p "nguyn b?n" v s? khng ?c c?p nh?t.

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