database rollback

Question

database rollback

Pete Peters

SSC-Addicted

Points: 410
More actions
November 28, 2005 at 8:50 am

#88579

I am aware that a datbase can be restored to a point in time but under sql server is there a way to roll the entire database back to a point in time without doing a restore first. Do you always have to do a restore from a backup prior to recovering/restoring to a time point

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Mike Metcalf SSCrazy Eights Points: 8763 More actions · Answer 1

Hi Pete,

Yes, the only way to do a point in time restore is to do a restore of the full DB (with norecovery set) followed by everything up to the transaction log that includes the time that you want to stop at.

Hope this helps

Phil Parkin SSC Guru Points: 246978 More actions · Answer 2

Hi Mike

I think that your answer should start with 'No' rather than 'Yes'

--edit-- I think you were answering question 2 - I was referring to question 1

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

dbuchan SSCrazy Points: 2328 More actions · Answer 3

Phil, shoudn't you have said "- I am referring to question 1" ? Unless there is a missing item in this message thread...

The systems fine with no users loggged in. Can we keep it that way ?br>

Phil Parkin SSC Guru Points: 246978 More actions · Answer 4

Actually, I should have left this thread well alone

But the original post contains two questions - that is how I came up with my rubbish answer!

Think I'd better have a quiet day today

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Vladan SSC-Insane Points: 22072 More actions · Answer 5

LOL... actually there are no questions in the original post, at least from the point of view that there are no question marks :-). The phrasing suggests that the poster meant to ask, but without question marks it is easy to overlook one of the two intended questions . In fact both "Yes" and "No" could be considered correct answer.