Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Recover Database with DUMP and LDF File

Posted on 2014-01-09
1
Medium Priority
?
277 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 70

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

598 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