Solved

Recover Database with DUMP and LDF File

Posted on 2014-01-09
1
254 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
1 Comment
 
LVL 69

Accepted Solution

by:
ScottPletcher earned 500 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Suggested Solutions

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
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.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

747 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now