<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
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Lynn Pettis
»
Backups
59 posts, Page 6 of 6
««
«
2
3
4
5
6
Backups
Rate Topic
Display Mode
Topic Options
Author
Message
magasvs
magasvs
Posted Friday, April 30, 2010 12:57 PM
Ten Centuries
Group: General Forum Members
Last Login: Monday, May 20, 2013 8:54 AM
Points: 1,259,
Visits: 700
I replied "No" because I would restore to the point of time when restored the last log backup.
Post #914015
jlennartz
jlennartz
Posted Friday, April 30, 2010 2:31 PM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Yesterday @ 1:27 PM
Points: 579,
Visits: 871
Good learn question for me Lynn.
I got it wrong because I analysted it to much and now hind sight is always better than foresight.
I figured the Wednesday 8AM Differential should be the one to use as it was the last differntial but if you used it you would miss all transactions from the 4PM Tuesday difference until the 6PM Tuesday Full becasue the Wednesday differentials use the Tuesday 6PM Full as a starting point.
Thanks for the excellent QotD Lynn.
Post #914073
Lynn Pettis
Lynn Pettis
Posted Friday, April 30, 2010 3:00 PM
SSC-Insane
Group: General Forum Members
Last Login: Today @ 2:45 AM
Points: 21,630,
Visits: 27,485
Shriniket (4/30/2010)
Lynn Pettis (4/30/2010)
... With that said, it is a matter of interpration based on context. ...
I think that says it, maybe this could have been a trick question where latest differential did mean Wed 8am which would question one's knowledge of how back ups work ... any how ... please don't apologize, very good question and makes for interesting conversation
Actually, I was trying to be a bit sarcastic with the apology, guess that didn't translate very well in the written word. The way I said it as I typed it, that is another story.
Thank you for the feedback and I am glad you thought the question was a good one.
Lynn Pettis
For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here
or
when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here
and
here
Managing Transaction Logs
SQL Musings from the Desert
Fountain Valley SQL
(My Mirror Blog)
Post #914090
Jeffrey Williams 3188
Jeffrey Williams 3188
Posted Friday, April 30, 2010 4:35 PM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Friday, May 17, 2013 11:21 AM
Points: 4,317,
Visits: 9,216
Lynn, very good question - I got it right mostly because I have been harping on the same thing that you have :)
For those interested, the other option for restoring to a point in time would be:
1) Restore full backup from Monday with norecovery
2) Restore all transaction log backups from Monday to 9am Wednesday with norecovery
3) Restore tail log backup with recovery
Or, restore any differential taken before the Tuesday night full and after the Monday night full, and then restore all transaction log backups to the point in time you want.
The important thing here is that you have an unbroken log chain (transaction log backups). As long as you have that, you can restore from any full backup.
Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
Post #914136
ChiragNS
ChiragNS
Posted Monday, May 03, 2010 4:24 AM
SSCrazy
Group: General Forum Members
Last Login: Wednesday, April 24, 2013 5:02 AM
Points: 2,365,
Visits: 1,825
I misread the question. Got the point only after looking at some posts
"Keep Trying"
Post #914564
Minnesota - Viking
Minnesota - Viking
Posted Wednesday, May 05, 2010 7:06 PM
SSC Veteran
Group: General Forum Members
Last Login: Wednesday, April 03, 2013 9:54 AM
Points: 201,
Visits: 456
I got it WRONG
But i love this part of your reply to "awoodhouse"
Wrong, you have to use the most recent differential backup based on the full backup file you are restoring, not just the most recent differential taken. Remember the full backup starts the base for subsequent differential backups.
--Lynn Pettis
Coz i was thinking in this lines....
I was scratching my head thinking that Latest Diff Back up is on Wed Morning @ 8 AM
Awesome..
Do you have a blog or site of your own..
I am looking for such tricky questions in the DBA Track..
==================================
Today is the tomorrow you worried about yesterday
Post #916612
bgdjwoods
bgdjwoods
Posted Friday, May 07, 2010 8:02 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: 2 days ago @ 10:42 AM
Points: 100,
Visits: 266
Hi all, I don't typically comment on these questions but I must chime in on this one. I agree with those who think this answer is incorrect. Based on Microsoft's own definition of a Differential backup: A backup of all files in the database. This backup contains only the data extents that were modified since the most recent database backup of each file.", there is no way that restoring Tuesday's differential would allow you to have the ability to successfully complete the point in time restore. I have done a LOT of restores and have even had to in an emergency situation but I have never considered or performed this type of restore; but I will.
Post #917983
prakskarry
prakskarry
Posted Friday, July 23, 2010 1:03 AM
Valued Member
Group: General Forum Members
Last Login: Wednesday, September 26, 2012 9:03 PM
Points: 66,
Visits: 161
The answer would be 'YES' here as FULL BACKUP Of Tuesday is curropt and following differential backups will capture the extents changed since last full backup.I got traped in the question.
Post #957792
sbamaty
sbamaty
Posted Friday, October 15, 2010 9:53 AM
SSChasing Mays
Group: General Forum Members
Last Login: Wednesday, May 22, 2013 11:03 AM
Points: 628,
Visits: 102
I misread the question too...when I got my answer incorrect, I went back and re-read and I was like "Stupid me". Anyway, after all, good question.
Post #1005320
« Prev Topic
|
Next Topic »
59 posts, Page 6 of 6
««
«
2
3
4
5
6
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.
