Restoring to point in time

• Abhishek Kotha

  SSC Eights!

  Points: 924

  More actions

  August 18, 2007 at 4:12 am

  #117878

  Hello everybody,

  I have a small problem,

  thursday morning I had full backup of my user database and every 1 hour I had transaction log backup.

  so, it goes like this

  full backup - 8:00 AM

  transaction - 9:00 AM

  transaction - 10:00 AM

  transaction - 11:00 AM

  transaction - 12:00 PM

  transaction - 1:00 PM

  some one deleted a table at 10:45 AM

  How can I restore all the transaction logs with minimal data loss

  please tell the procedure

  Till 10:45 AM I can go for point in time restore after that what should I do?

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  August 18, 2007 at 7:10 am

  #727815

  Please do not cross post, we check all questions regardless of the board.

   

  Continue this thread here : http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=357&messageid=391847