Array controller and lost data.

Hi,
I had some problem with our server, SQL Server stopped and W2k Server could
not response. I had to use button ON/OFF.
I find out the array controller was wrong so I change it.
When server was started I found message in system log about error on device
\Device\Harddisk0\DR0 and another errors in SQL errorlog:
2005-10-12 10:20:30.06 spid2 LogWriter: Operating system error 1117(The
request could not be performed because of an I/O device error.) encountered.
2005-10-12 10:20:30.06 spid2 Write error during log flush. Shutting down
server
2005-10-12 10:20:30.12 spid10 Error: 9001, Severity: 21, State: 4
2005-10-12 10:20:30.12 spid10 The log for database 'DSL' is not available..
2005-10-12 10:20:30.88 spid2 LogWriter: Operating system error 1117(The
request could not be performed because of an I/O device error.) encountered.
2005-10-12 10:20:30.88 spid2 Write error during log flush. Shutting down
server
2005-10-12 10:20:30.88 spid68 Error: 9001, Severity: 21, State: 4
2005-10-12 10:20:30.88 spid68 The log for database 'msdb' is not
available..
2005-10-12 10:20:31.20 spid15 Database 'MyDB' cannot be opened. It has
been marked SUSPECT by recovery. See the SQL Server errorlog for more
information.
2005-10-12 10:20:31.21 spid15 Database 'MyDB' cannot be opened. It has
been marked SUSPECT by recovery. See the SQL Server errorlog for more
information.
2005-10-12 10:20:31.21 spid15 Database 'MyDB' cannot be opened. It has
been marked SUSPECT by recovery. See the SQL Server errorlog for more
information.
2005-10-12 10:20:31.26 spid15 fcb::close-flush: Operating system error
1117(The request could not be performed because of an I/O device error.)
encountered.
2005-10-12 10:20:31.26 spid15 Starting up database 'MyDB'.
2005-10-12 10:20:32.26 spid16 Starting up database 'msdb'.
2005-10-12 10:20:32.54 spid15 Error: 823, Severity: 24, State: 2
2005-10-12 10:20:32.54 spid15 I/O error 1117(The request could not be
performed because of an I/O device error.) detected during read at offset
0x00000016760000 in file 'D:\Program Files\Microsoft SQL
Server\MSSQL\Data\MyDB.mdf'..
2005-10-12 10:20:32.56 spid15 Error: 3313, Severity: 21, State: 2
2005-10-12 10:20:32.56 spid15 Error while redoing logged operation in
database 'MyDB'. Error at log record ID (33351:450:4)..
2005-10-12 10:20:32.62 spid2 LogWriter: Operating system error 1117(The
request could not be performed because of an I/O device error.) encountered.
2005-10-12 10:20:32.62 spid2 Write error during log flush. Shutting down
server
2005-10-12 10:20:32.62 spid15 Error: 9001, Severity: 21, State: 4
2005-10-12 10:20:32.62 spid15 The log for database 'master' is not
available..
2005-10-12 10:20:32.64 spid15 Error: 3449, Severity: 21, State: 1
2005-10-12 10:20:32.64 spid15 An error has occurred that requires SQL
Server to shut down so that recovery can be performed on database ID 1..
After that I could not start SQL Server.
I made new installation of SQL server on new hardware and I made copy of
files MyDB.mdf and MyDB.ldf to new server.
I attached them to new server and started DBCC CHECKDB with no errors.
But when I made SELECT... to MyDB I found all data from 2005-10-12 were
lost.
Could you any body help me? What was happend? Where is the mistake?
Could I find the lost data in transaction log or tempbd or ...?
Thanks
Radek
Hi
It seems that your server failed on 2005-10-12 10:20:32.64 therefore the
best you can achieve is to recover up to that point. Any uncommitted
transactions would be rolled back when you attached the mdf/ldf file.
John
"RP" wrote:

> Hi,
> I had some problem with our server, SQL Server stopped and W2k Server could
> not response. I had to use button ON/OFF.
> I find out the array controller was wrong so I change it.
> When server was started I found message in system log about error on device
> \Device\Harddisk0\DR0 and another errors in SQL errorlog:
> 2005-10-12 10:20:30.06 spid2 LogWriter: Operating system error 1117(The
> request could not be performed because of an I/O device error.) encountered.
> 2005-10-12 10:20:30.06 spid2 Write error during log flush. Shutting down
> server
> 2005-10-12 10:20:30.12 spid10 Error: 9001, Severity: 21, State: 4
> 2005-10-12 10:20:30.12 spid10 The log for database 'DSL' is not available..
> 2005-10-12 10:20:30.88 spid2 LogWriter: Operating system error 1117(The
> request could not be performed because of an I/O device error.) encountered.
> 2005-10-12 10:20:30.88 spid2 Write error during log flush. Shutting down
> server
> 2005-10-12 10:20:30.88 spid68 Error: 9001, Severity: 21, State: 4
> 2005-10-12 10:20:30.88 spid68 The log for database 'msdb' is not
> available..
> 2005-10-12 10:20:31.20 spid15 Database 'MyDB' cannot be opened. It has
> been marked SUSPECT by recovery. See the SQL Server errorlog for more
> information.
> 2005-10-12 10:20:31.21 spid15 Database 'MyDB' cannot be opened. It has
> been marked SUSPECT by recovery. See the SQL Server errorlog for more
> information.
> 2005-10-12 10:20:31.21 spid15 Database 'MyDB' cannot be opened. It has
> been marked SUSPECT by recovery. See the SQL Server errorlog for more
> information.
> 2005-10-12 10:20:31.26 spid15 fcb::close-flush: Operating system error
> 1117(The request could not be performed because of an I/O device error.)
> encountered.
> 2005-10-12 10:20:31.26 spid15 Starting up database 'MyDB'.
> 2005-10-12 10:20:32.26 spid16 Starting up database 'msdb'.
> 2005-10-12 10:20:32.54 spid15 Error: 823, Severity: 24, State: 2
> 2005-10-12 10:20:32.54 spid15 I/O error 1117(The request could not be
> performed because of an I/O device error.) detected during read at offset
> 0x00000016760000 in file 'D:\Program Files\Microsoft SQL
> Server\MSSQL\Data\MyDB.mdf'..
> 2005-10-12 10:20:32.56 spid15 Error: 3313, Severity: 21, State: 2
> 2005-10-12 10:20:32.56 spid15 Error while redoing logged operation in
> database 'MyDB'. Error at log record ID (33351:450:4)..
> 2005-10-12 10:20:32.62 spid2 LogWriter: Operating system error 1117(The
> request could not be performed because of an I/O device error.) encountered.
> 2005-10-12 10:20:32.62 spid2 Write error during log flush. Shutting down
> server
> 2005-10-12 10:20:32.62 spid15 Error: 9001, Severity: 21, State: 4
> 2005-10-12 10:20:32.62 spid15 The log for database 'master' is not
> available..
> 2005-10-12 10:20:32.64 spid15 Error: 3449, Severity: 21, State: 1
> 2005-10-12 10:20:32.64 spid15 An error has occurred that requires SQL
> Server to shut down so that recovery can be performed on database ID 1..
> After that I could not start SQL Server.
> I made new installation of SQL server on new hardware and I made copy of
> files MyDB.mdf and MyDB.ldf to new server.
> I attached them to new server and started DBCC CHECKDB with no errors.
> But when I made SELECT... to MyDB I found all data from 2005-10-12 were
> lost.
> Could you any body help me? What was happend? Where is the mistake?
> Could I find the lost data in transaction log or tempbd or ...?
> Thanks
> Radek
>