Re: MDF File Corrupted?
From: Hari (hari_prasad_k_at_hotmail.com)
Date: 06/18/04
- Next message: Tibor Karaszi: "Re: Defragmentation of table"
- Previous message: Mingqing Cheng [MSFT]: "RE: To many indexes."
- In reply to: Chip: "MDF File Corrupted?"
- Next in thread: Dinesh T.K: "Re: MDF File Corrupted?"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 18 Jun 2004 11:08:14 +0530
Hi,
Execute DBCC CHECKDB to see if it is a corrupt database. Normally this type
of errors occur when there is a
hardware failure.
Can you restore the latest backup in a different SQL server and confirm
whether your data is safe or not.
-- Thanks Hari MCDBA "Chip" <Chipsin007@nospam.yahoo.com> wrote in message news:1e1ca01c454f3$e01fe7f0$a501280a@phx.gbl... > Hi Group, > > Pls guide me. > > Last night i scheduled a backup on a database. This > morning the database stopped working and shows this error > > Server: Msg 823, Level 24, State 1, Line 3 > I/O error 2(The system cannot find the file specified.) > detected during read of BUF pointer = 0x1424d9c0, page ptr > = 0x4308e000, pageid = (0x1:0x288), dbid = 9, status = > 0x801, file = d:\MSSQL7\data\Sales_Data.MDF. > > From EM I can see only few tables. Restarted the SQL > Service but still the problem exists. > > Regards > > Chip
- Next message: Tibor Karaszi: "Re: Defragmentation of table"
- Previous message: Mingqing Cheng [MSFT]: "RE: To many indexes."
- In reply to: Chip: "MDF File Corrupted?"
- Next in thread: Dinesh T.K: "Re: MDF File Corrupted?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
