Re: Restore log (multiple logs in 1 device)

From: Bob Simms (bob_simms_at_somewhere.com)
Date: 04/08/04 

Date: Thu, 8 Apr 2004 21:35:18 +0100

"Cris" <anonymous@discussions.microsoft.com> wrote in message
news:FF7A1E18-6A5E-4671-84F4-DE6FB1F4B8B6@microsoft.com...
> Hi everyone,
> The way I take my backups is to put a full backup in a
device in the beginning of the week and every hour I take a log backup. So,
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, 2004
at 9:45), I put all the logs in the request like that:
>
> restore database AAA from DeviceA with norecovery
> restore log AAA from DeviceA with file=2, norecovery
> restore log AAA from DeviceA with file=3, norecovery
> restore log AAA from DeviceA with file=4, norecovery
> ...
> restore log AAA from DeviceA with file=158 recovery stopat = '2004-04-08
9:45:00'
>
> Is their a better way to do this ?

This is the only way to restore the backups as you are taking them. You
could try taking differential backups every now and then, which would speed
up recovery time.

e.g. if you do a full backup once a week, log backups every hour and a
differential backup every midnight, if on Friday you want to restore to 0945
then you would need to recover your full backup, your Thursday night
differential back up then just the log backups from your last differential. 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.655 / Virus Database: 420 - Release Date: 08/04/2004

Relevant Pages

  • Re: Trans Log Maintenance
    ... If you skip using differential backups and it would take too long time to restore from full and transaction log backups. ... I'm trying to implement an efficient way to manage trans log in a prod ...
    (microsoft.public.sqlserver.setup)
  • RE: Could making an extra backup cause data loss?
    ... As mike says - the good thing about log backups is that they are not affected ... > server and doesn't tell Alice. ... > What happens if Alice wants to do a restore at 1201? ...
    (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: SQL 2000 - Replication and LDF file
    ... this will not aid in recoverability. ... log backups to be able to restore to a point in time. ... recovery mode and backup the database typically daily and the logs much more ...
    (microsoft.public.sqlserver.replication)
  • Re: Huge log file - 500 MB Data, 7 GB Log file
    ... If you don't do log backups, then the log will not be emptied when the db is ... Either set the db in simple recovery mode or do ... I'm a bit surprised by doing db and diff backups only. ...
    (microsoft.public.sqlserver.server)