Restore: Point in time

Question

Restore: Point in time

QPR

SSC Eights!

Points: 814
More actions
July 21, 2005 at 9:42 pm

#90326

Is it possible to do this using the current log or just from those in the back up history?

Viewing 9 posts - 1 through 8 (of 8 total)

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

Ford Fairlane SSCertifiable Points: 7664 More actions · Answer 1

Hi,

To do a point in time recovery you need to apply all previous logs up until the time needed. The current log would restore you to the time that THAT log (the current) was backed up.

Hope this helps....

Hope this helps...

Ford Fairlane
Rock and Roll Detective

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 2

- You just need sqlserver backups to be able to restore. The backup-history is just a help-set for EM to determine a gui for restore. You can restore on another server then the backup has been created from. (encryption ? )

- to perform a restore :

First of all your database cannot reside in "simple" recovery mode.

Second, you need a FULL backup.

Then, depeding on your backup-strategy, the latest Differential backup (created after the fullbackup). (diff backups are incremental)

Then the needed log-backup(s), in sequence, (created after the latest differential back (if you have one) and Fullbackup)

There can be no "gaps" in your sequences.

- Check out Restore Database in Books Online.

- perform a search at http://www.sqlservercentral.com for "restore" and you'll find a bunch of nice articles

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

QPR SSC Eights! Points: 814 More actions · Answer 3

Not sure if explained that properly.

All of a sudden someone makes a horredous oops!

Can I use the log currently attached and go back to 5 minutes before the oops, or is this sort of point in time restore only possible with a backed up transaction log.

I suppose a better way to ask would be... Can you roll back X number of minutes?

Sorry if I've made things even blurrier... it's first thing Monday morning here

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 4

if I'm correct Log P.I. can do such action.

SQLServer itself cannot, unless you do a full restore to point in time.

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

homebrew01 SSC Guru Points: 55548 More actions · Answer 5

There are some 3rd party tools that can do it. We use Lumigent Log Explorer, but there are others too.

QPR SSC Eights! Points: 814 More actions · Answer 6

Thanks, I looked at the trial version of Log Explorer and really liked it. It was a bit pricey though. Value for money you reckon?

It was the "per server" bit that made it expensive IMHO.

noeld SSC Guru Points: 96590 More actions · Answer 7

Well if you could move your "important" DB to one server then the "per server" bit will not matter

* Noel

QPR SSC Eights! Points: 814 More actions · Answer 8

true but we have 2 most important products/dbs each designed to live on their own instance