Solved

SQL - Full, Simple, Transaction Logs

Posted on 2010-11-12
2
307 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 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 63 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 62 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

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, …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

896 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

12 Experts available now in Live!

Get 1:1 Help Now