?
Solved

Recover Database with DUMP and LDF File

Posted on 2014-01-09
1
Medium Priority
?
273 Views
Last Modified: 2014-03-04
Hello,

     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?
0
Comment
Question by:FNDAdmin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 69

Accepted Solution

by:
Scott Pletcher earned 2000 total points
ID: 39769708
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.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question