Re: Data lost after rebuilding new txn log after disk failure

From: Uri Dimant (urid_at_iscar.co.il)
Date: 01/04/05 

Date: Tue, 4 Jan 2005 15:23:56 +0200

Jon
Have you performed LOG file backup?
When the disk is faild you was be able to run BACKUP LOG file WITH NO
TRUNCATE option. Restore the whole database and apply all log files with NO
RECOVERY option and the last one with RECOVERY option.
For more details you have to read BOL.
Sorry about losing the data.

"Jon A" <jon@pitstart.com> wrote in message
news:ePC79xl8EHA.2568@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> Had a problem recently with some lost data after a disk in one of our DB
> servers failed.
>
> The DB server was given separate physical disks to split the data and txn
> log files on different disks to guard against disk failure.
>
> The disk with the txn log failed at 14:30. We got the DB online again
pretty
> quickly by building a new log file for the DB. However, the last data in
the
> DB was written at 11:45. I'm not expecting to recover the data now but was
> confused to see the lost data.
>
> I thought the dat/mdf files should have contained nearly all the data upto
> the point the DB failed because of the disk failure. Am I missing
something
> here?
>
> Is there anything I should be checking on the server ?
>
> TIA,
>
> Jon A
>
> London, UK
>
>

Relevant Pages

  • Re: Data lost after rebuilding new txn log after disk failure
    ... How did you "build a new log file"? ... Tibor Karaszi, SQL Server MVP ... > Had a problem recently with some lost data after a disk in one of our DB servers failed. ... > disks to guard against disk failure. ...
    (microsoft.public.sqlserver.server)
  • Performance Monitor statistic listed but no data generated?
    ... I am trying to generate log files on free disk space on a file server ... The server has two 36GB drives in hardware RAID1 ... will just not have an entry for E: in the log file. ...
    (microsoft.public.windows.file_system)
  • Re: SQL Server 2000 Performance - 10K vs. 15K
    ... Anyway, what about moving the tempdb log file, since it is on the ... I'm getting a message in event viewer that the tempdb log file is ... plenty of disk space. ... >>> the client on the server, and still have to same issue. ...
    (microsoft.public.sqlserver.setup)
  • Re: Balance I/O
    ... Is it a good idea to decrease the disks which are near 100% busy? ... files on the same disk spindle? ... Redo log file switch frequency (only need to execute this the last ... session to determine the SQL statements executed by the session, ...
    (comp.databases.oracle.server)
  • RE: RAM usage during I/O
    ... > another hard disk? ... Specify a name for the log file and click OK. ... > Windows uses all available physical RAM. ...
    (microsoft.public.windowsxp.help_and_support)