How get .ldf if .mdf broken ?

All Replies

• Thursday, October 29, 2009 12:42 AMLekss

   
  

  0

  Sign In to Vote
  1. Do restore with full backup - NO RECOVERY
  2. Restore the differential backup with overwrite existing option - NO RECOVERY
  3. Restore the first tran log backup - NO RECOVERY
  4. Restore the second tran log backup - NO RECOVERY
  5. Restore the third tran log backup - NO RECOVERY
  6. Restore the fourth tran log backup - RECOVERY MODE

  ---

  Thanks, Leks
  • Reply
  • Quote

   
• Thursday, October 29, 2009 1:05 AM90350

   
  

  0

  Sign In to Vote
  Thanks Leks.
  
  However we still need data after 4th backup.
  
  How we can get / backup .ldf between 4th and 5th backups?
  
  Thanks.
  • Reply
  • Quote

   
• Thursday, October 29, 2009 1:46 AMLekss

   
  

  0

  Sign In to Vote
  I guess you are unsafe here , If you dont have tran log backups between 4 and 5th schedule  , you can only recover the database until that point (4th transaction log)

  ---

  Thanks, Leks

  • Proposed As Answer byXiao-Min Tan – MSFTMSFT, ModeratorFriday, October 30, 2009 7:59 AM
  • Marked As Answer by90350 Tuesday, November 03, 2009 5:40 PM
  •  
  • Reply
  • Quote

   
• Thursday, October 29, 2009 3:30 AMNimit Parikh

   
  

  0

  Sign In to Vote
  Try to take the Tail-Log Backup. If you are unable to take tail log backup then :(

  
  

  Link 2 Article

  Like any log backup, a tail-log backup is taken by using the BACKUP LOG statement. We recommend that you take a tail-log backup in the following situations:

  • If the database is online, before starting a restore sequence, back up the tail of the log using WITH NORECOVERY whenever the next action you plan to perform on the database is a restore operation: 
    BACKUP LOG database_name TO <backup_device> WITH NORECOVERY
    

    Note:
    To avoid an error, the NORECOVERY option is necessary.

     

  • If the database is offline and does not start.
    Try to take a tail-log backup. Because no transactions can occur at this time, using WITH NORECOVERY is optional. If the database is damaged, use either WITH CONTINUE_AFTER_ERROR or WITH NO_TRUNCATE. 
    BACKUP LOG database_name TO <backup_device> [WITH { CONTINUE_AFTER_ERROR | NO_TRUNCATE }
    

    Important:
    We recommend that you avoid using NO_TRUNCATE, except when the database is damaged.

     

    If the database is damaged, for example, if the database does not start, a tail-log backup succeeds only if the log files are undamaged, the database is in a state that supports tail-log backups, and the database does not contain any bulk-logged changes. 
  • Reply
  • Quote

   
• Thursday, October 29, 2009 4:55 AMSNIVAS

   
  

  0

  Sign In to Vote
  Hello 90350
  
  I guess Leks answered your question ...and Nimit Parikh given some more stuff...
  
  
  
  --> Crash happened between 4th and 5th TLog backups. How we can restore Dbase? 
  Explain little bit more about Crash... OS Crash...SQL Server Crash....or  DB Crash
  then you get more details.
  
  
  
  
  
  
  

  ---

  SNIVAS

  • Marked As Answer by90350 Tuesday, November 03, 2009 5:39 PM
  • Unmarked As Answer by90350 Tuesday, November 03, 2009 5:40 PM
  •  
  • Reply
  • Quote