Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Possible to skip transaction log for restore?

Author  Topic 

MorrisK
Yak Posting Veteran

83 Posts

Posted - 2014-11-13 : 10:13:16
I have a full backup made at 5:30 PM yesterday. Overnight an automated job posted some bad transactions. I have hourly transaction log backups made beginning at 6:00 AM this morning.

Can I -

1. Restore the full backup
2. Begin restoring the transaction logs beginning with the 7:00 AM backup?

I don't care about any transactions in the 6:00 AM backup.

Here's a picture of what my backup contains.

[url]http://1drv.ms/1wsiwOG[/url]

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-11-13 : 12:14:49
That is not possible. The transaction log backups are a chain. You can't skip any after the full or differential base.

Why is there a several hour gap in tlog backups at night? I've never understood that strategy. Regardless of activity at night, I'm of the opinion that the frequency shouldn't change.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2014-11-14 : 08:24:42
quote:
Originally posted by tkizer

Why is there a several hour gap in tlog backups at night? I've never understood that strategy. Regardless of activity at night, I'm of the opinion that the frequency shouldn't change.


Agreed. We actually increase the frequency during the night, whilst index rebuilds are running, because they are more likely to fill up the LOG file faster than any "normal" transactions during the day
Go to Top of Page
   

- Advertisement -