Unix Technical Forum

Re: Point in time restore

This is a discussion on Re: Point in time restore within the SQL Server forums, part of the Microsoft SQL Server category; --> > Somehow I had the idea that the current transaction log can be used with a > point in ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > SQL Server

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-28-2008, 06:00 PM
Marcin \Helpik\ Kaluza
 
Posts: n/a
Default Re: Point in time restore

> Somehow I had the idea that the current transaction log can be used with a
> point in time restore operation.


Yes.

> But I now have the idea that point in time restore can only be used when a
> transaction log backup has taken place.


Transaction log keeps all changes made to the db from the time it's been
last backed up (i.e truncated). Now imagine following: You've made a full db
backup (this includes log as well) at 10 pm, used your db happily up to
11:30 PM when your HDD crashes and your DB is gone. Since you're a smart guy
you've kept your transaction log on separate device. Your situation is as
follows: You've got the state from 10 PM on your tape + all the changes made
between 10 pm and 11:30 pm in your log. All you have to do is
1) Backup your existing log (one that is still available) with NO_TRUNCATE
option
2) Restore your DB from the tape
3) Restore all your log backups (in this case just one that ypu've made at
point 1)

You've got the state from 11:30 PM. (Or if you want to you may restore it to
the state it was at 10:30)

---
HTH

Marcin

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 12:30 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com