Re: Trans Log Maintenance

Tech-Archive recommends: Speed Up your PC by fixing your registry

I don't think it's an efficient way.

For example, in my lastest project I talked to my customer and asked him: "How much data can you afford to lose?" and their answer was "15 min" so I planned a backup strategy as follows:

Full backup: 00:00
Differential backup: Every six hours from 06:00 to 18:30
Log backups: Ever 15 min from 00:15 to 23:50

If you skip using differential backups and it would take too long time to restore from full and transaction log backups.

Today I heard a story that Paul Randal experienced, he told it on technet radio. He said that there was a bank and they took a full backup in 2004 and since then they were taking only transaction log backups and their database corrupted so they needed to restore their database from the backups and it took their 3 days to restore from that one full backup (which was taken 3-4 years ago) and log backups, can you imagine?

Of course your story wouldn't be like that bank's however I believe you got it.

--
Ekrem Önsoy



"Socrates" <Socrates@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:EA1B9539-D531-4867-A1D4-3EB656BB8FF1@xxxxxxxxxxxxxxxx
Hi,

I'm trying to implement an efficient way to manage trans log in a prod
environment (recovery model full) with the following backup strategy:
- hourly trans log backups
- nightly full backups

Any help is greatly appreciated.

Thanks,



.

Relevant Pages

  • Re: Restore log (multiple logs in 1 device)
    ... at the end of the week I can have more than 150 log backups in the device. ... If I would like to restore my database at the end of the week(April 8, ... > restore database AAA from DeviceA with norecovery ... This is the only way to restore the backups as you are taking them. ...
    (microsoft.public.sqlserver.server)
  • Re: Failing Log Backups
    ... Not sure if this will help given the error message, but I do tend to find ... that logical disk corruption does cause odd behaviour sometimes. ... We do weekly full backups, ... then the log backups would run fine after. ...
    (microsoft.public.sqlserver.server)
  • Re: Failing Log Backups
    ... had you been doing test restores of your backups to make sure they were ... SQL Server MVP ... log backups for the above database began to fail, ... would be fine with the log backups. ...
    (microsoft.public.sqlserver.server)
  • Re: Trimming HUGE Transaction Log
    ... say backup the database, I really mean both. ... I added differential backups ... Most installations use fairly frequent log backups (depending ...
    (microsoft.public.sqlserver.tools)
  • Re: Recommended best practices for log backups and system db backups??
    ... One problem if you have all log backups in the same file, ... and I decided to restore it at the state at 3:55 in the morning. ... I found that the backups where set up so that log backups ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.server)