• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 292
  • Last Modified:

Recover Database with DUMP and LDF File


     We are running SQL 2008 R2 and the recovery model is set to FULL. We backup the database and transaction log every night.

     If the database corrupts during the day can I restore the database from the previous night's backup and use the physical LDF file and perform a Point-In-Time restore right up to the point prior to corruption?
1 Solution
Scott PletcherSenior DBACommented:
Typically, yes.

You do a tail-log backup on the trans log FIRST, immediately after any corruption but BEFORE you run any restore, recovery, etc..  Only if you can't get a tail-log backup will you not be able to recover.

It's safer to run either a log backup or a db differential backup periodically if you need more assurance that you can recover further forward in time than just the last full backup.

Btw, it doesn't really help to do a t-log backup immediately before or after a full back -- instead, do your tranlog backups <nn> hours after the full backup, so that they give you additional recovery possibilities.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now