Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL - Full, Simple, Transaction Logs

Posted on 2010-11-12
2
Medium Priority
?
318 Views
Last Modified: 2012-05-10
I've been doing some research on SQL and have already asked some SQL related questions in this forum.  The more research I do seems to lead to more questions.

Let's say your db is in full recovery mode and you take daily full backups.  I understand ideally you take transaction log backups once per hour (depending on your environment).  For arguments sake, what if you backup the transaction log once a day.  Then, for restore purposes, could you only go back to the full backup and the last backup of your Tlog?
0
Comment
Question by:Kram80
2 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 252 total points
ID: 34123176
you can restore the full backup, and then apply as much of that transaction log backup as you wish.

the only issue is that you will only have that single transaction log backup, so basically, you risk to loose ALL the changes done since the full backup until the transaction log backup is done.
however, if you have a " disaster ", you might not have the chance to do another t-log backup ... and there goes a full day of work.
0
 
LVL 15

Assisted Solution

by:JimFive
JimFive earned 248 total points
ID: 34124687
There are two issues.

The first, mentioned by angelIII is that of data recovery.  The other issue is that, in Full recover mode,  the transaction log continues to grow until it is backed up.  In a busy database the log file can get very large in one day.
--
JimFive
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
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.
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

578 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