<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server Newbies
»
Can't restore transaction logs
14 posts, Page 2 of 2
««
1
2
Can't restore transaction logs
Rate Topic
Display Mode
Topic Options
Author
Message
anthony.green
anthony.green
Posted Thursday, November 15, 2012 3:51 AM
SSCertifiable
Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075,
Visits: 4,831
GilaMonster (11/15/2012)
anthony.green (11/15/2012)
Then you must be using an earlier full backup and not the current one from the latest 10:30 backup.
This.
A backup that starts at 10:30 and finishes at 11:30 may well need the tran log backup from 10:00 and the one from 11:00 (plus all later), but it could not need any from before that.
Appreciate that but if the 10pm transaction log was still to recent to restore to the 10:30pm full backup then I assumed that the full backup is ealier in the transaction log chain, possibly from the night before
Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1
&
Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger
Post #1385060
GilaMonster
GilaMonster
Posted Thursday, November 15, 2012 3:55 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 7:23 AM
Points: 37,738,
Visits: 30,009
anthony.green (11/15/2012)
Appreciate that but if the 10pm transaction log was still to recent to restore to the 10:30pm full backup then I assumed that the full backup is ealier in the transaction log chain, possibly from the night before
Err... that's what I said.
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1385065
anthony.green
anthony.green
Posted Thursday, November 15, 2012 4:08 AM
SSCertifiable
Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075,
Visits: 4,831
GilaMonster (11/15/2012)
anthony.green (11/15/2012)
Appreciate that but if the 10pm transaction log was still to recent to restore to the 10:30pm full backup then I assumed that the full backup is ealier in the transaction log chain, possibly from the night before
Err... that's what I said.
Sorry, I must of miss interpreted
Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1
&
Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger
Post #1385074
patrickmcginnis59
patrickmcginnis59
Posted Thursday, November 15, 2012 11:12 AM
SSC-Addicted
Group: General Forum Members
Last Login: Wednesday, January 16, 2013 4:23 PM
Points: 415,
Visits: 2,333
anthony.green (11/15/2012)
GilaMonster (11/15/2012)
anthony.green (11/15/2012)
Then you must be using an earlier full backup and not the current one from the latest 10:30 backup.
This.
A backup that starts at 10:30 and finishes at 11:30 may well need the tran log backup from 10:00 and the one from 11:00 (plus all later), but it could not need any from before that.
Appreciate that but if the 10pm transaction log was still to recent to restore to the 10:30pm full backup then I assumed that the full backup is ealier in the transaction log chain, possibly from the night before
I swear this reads like there are multiple full backups in the backup file because the backup file was not initialized. Maybe check to see how many full backups are actually in the full backup file just on the chance that this is the case?
Post #1385282
« Prev Topic
|
Next Topic »
14 posts, Page 2 of 2
««
1
2
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
