Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004

    Unanswered: Backing up online log after loss of primary data file

    My question is this:

    Is there anyway to backup the current online log after complete loss of the current correponding datafile?


    (2) Logical Disk Volumes

    Disk 1 (D contains pubs_data.mdf
    Disk 2 (E contains pubs_log.ldf

    Disk 1 becomes corrupt and goes offline leaving the the database pubs in a suspect state. Is backup of the current online log pubs_log.ldf possible? If a backup of the log is not possible are there any other restoration methods that can be used to bring this database back online, rescuing as much information as possible from the current online log pubs_log.ldf.


  2. #2
    Join Date
    May 2004

    The sounds of Crickets chirping

    I can't beleive there is no way to get at the information in the current online log depite the fact that the database file is gone.

    So, if I can't get at the current online log I must rely on a backup of the log which I would take every 5 or 15 minutes but that 0-5 minute period is not retrievable even if its just the data file that fails.

    Any thoughts?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts