Is transaction log file reuseable after data file is Restored?

From: Paul Ritchie (pritREMOVEchie_at_xtREMOVEra.co.nzREMOVE)
Date: 12/14/04 

Date: Tue, 14 Dec 2004 16:03:34 +1300

We have a database that is set to Simple recovery mode and is backed up
every night. The data files and sql server and OS files are on the same
disk and the log file is on a different disk. (There are no log file
backups.)

During the day the disk controller on the disk with the data files has
failed and has subsequently been replaced and is being restored from tape.

My question is: can the log file on the other (healty) disk be reliably used
to "replay" it's committed transactions into the restored database?

thanks,
Paul Ritchie.

Relevant Pages

  • Re: General Question
    ... Another thing to consider is the size your log file can ... grow to if your database is particularly busy. ... >another disk now. ...
    (microsoft.public.sqlserver.clients)
  • RE: Disk Full Problem....
    ... We tried to delete as much as possible but still the database is ... Can we move mysql data files to a different volume and ask the endine to ... Subject: Disk Full Problem.... ...
    (RedHat)
  • Re: Import problems on Windows Server
    ... import log file, it did not complete import of all the tables. ... looked in database it has all the tables, views etc, so import ... tablespaces so there is room there, but no room to write the log? ... Fragmented disk misleading you about ...
    (comp.databases.oracle.server)
  • Re: Is transaction log file reuseable after data file is Restored?
    ... When you restore the FULL Database backup, ... The data files and sql server and OS files are on the same disk and the log file is on a different disk. ...
    (microsoft.public.sqlserver.server)
  • basic tlog question
    ... written to the log file first? ... I understand the part where dirty pages are written to disk.. ... is when it talks about writing to disk, is it referring to the data files on ...
    (microsoft.public.sqlserver.server)
Quantcast