How to restore Point In Time in this situation ?
in [Server Configuration]
|
From: Tibor Karaszi on 17 Mar 2010 07:44 That was easier... :-) > Is there any way to restore database point in time to 16:25 by using > 0:2:00 Full + Transaction Logs ? Yes. Just restore the 02:00 full backup, and all subsequent log backups (specifying 16:25 for STOPAT when you restore the 17:00 log backup). I.e. a db backup do not affect the log backup chain. -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Patrick" <Patrick(a)discussions.microsoft.com> wrote in message news:OsCW3vbxKHA.5036(a)TK2MSFTNGP02.phx.gbl... > Dear all, > > Many thanks for your advice. > > 02:00 Full (Maintenance Plan) > 07:00 Log > ..... > 14:00 Log > 15:00 Log > 16:00 Log > 16:02 Full (Manual / No longer available - overwritten) > 16:15 Full (Manual / No longer available - overwritten) > 16:23 Full (Manual / No longer available - overwritten) > 16:45 Full (Manual) > 17:00 Log > > Is there any way to restore database point in time to 16:25 by using > 0:2:00 Full + Transaction Logs ? > > Thanks again > Patrick > > > On 16/03/2010 10:11 PM, Tibor Karaszi wrote: >> Whenever the GUI acts up on you, do it yourself. I have read the post >> several times, but I can't make heads or tails of what backups you >> produced and what are still available (those not available has been >> overwritten using INIT, perhaps). If you can post such a description, it >> would be much easier for us to help. Something like: >> >> 13:00 Full >> 13:30 Log >> ... >> 14:40 Log >> 14:45 Full (no longer available - overwritten) >> 14:50 Log >> >> With above information, we will be able to tell you what restore options >> you have. Note that the GUI will only base its restore suggestion on >> backup history - it will not verify that the stuff is still there.... >> >
From: Patrick on 17 Mar 2010 16:56
Dear Tibor, Many thanks for your advice. Much appreciated. Regards, Patrick On 17/03/2010 10:44 PM, Tibor Karaszi wrote: > That was easier... :-) > >> Is there any way to restore database point in time to 16:25 by using >> 0:2:00 Full + Transaction Logs ? > > Yes. Just restore the 02:00 full backup, and all subsequent log backups > (specifying 16:25 for STOPAT when you restore the 17:00 log backup). > I.e. a db backup do not affect the log backup chain. > |