Point in time recovery issue

Hey all,
I've been playing around with point in time recoveries and
encountered a weird issue. Some background info:
I performed a full back, a differential and then some transaction log
backups. I made data changes at set intervals and I can recover to
points in time between those without any issue.
Here's the problem... When you click on point in time recovery a
window pops up prompting you for a time. The default thats in there
appears to be the time of the last transaction log, so i'm assuming
that would be the maximum time you could restore to. If I click on
OK the restore proceeds and completes successfully. But, when I go
back to the EM console the database is marked as Loading and in the
logfile it says:
Bypassing recovery for database 'myTest' because it is marked IN LOAD.
If I repeat the process and do another point in time recovery but
select a time 10 seconds before the default time the database recovers
fine. If I do a full restore using the last transaction log it works
fine as well.
I searched on google, technet, etc but no luck... I'm not overly
concerned but curious as to why the database isn't recovering
properly.
DaveCould it be that you for some reason didn't specify WITH RECOVERY for that
last log restore? Try doing this using TSQL instead of EM (you can catch the
commands that EM sends with Profiler and then execute them in query
analyzer. And make sure that you specify WITH RECOVERY for that last log
restore.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Dave" <shoad316@.hotmail.com> wrote in message
news:78cf0572.0311110909.4a320140@.posting.google.com...
> Hey all,
> I've been playing around with point in time recoveries and
> encountered a weird issue. Some background info:
> I performed a full back, a differential and then some transaction log
> backups. I made data changes at set intervals and I can recover to
> points in time between those without any issue.
> Here's the problem... When you click on point in time recovery a
> window pops up prompting you for a time. The default thats in there
> appears to be the time of the last transaction log, so i'm assuming
> that would be the maximum time you could restore to. If I click on
> OK the restore proceeds and completes successfully. But, when I go
> back to the EM console the database is marked as Loading and in the
> logfile it says:
> Bypassing recovery for database 'myTest' because it is marked IN LOAD.
> If I repeat the process and do another point in time recovery but
> select a time 10 seconds before the default time the database recovers
> fine. If I do a full restore using the last transaction log it works
> fine as well.
> I searched on google, technet, etc but no luck... I'm not overly
> concerned but curious as to why the database isn't recovering
> properly.
> Dave|||Thanks for the info, I was using EM to do the recover and in the options tab
it defaults to full recovery I believe.
I'm new to SQL Server so i'm not familiar with using the CL yet but i'll
give it a shot tomorrow.
thanks
--
--
david.best@.sympatico.ca
"Thanks to the remote control I have the attention span of a gerbil!"
"There are 10 types of people in the world. Those who understand binary,
and those who don't."
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:%235gDHxIqDHA.1096@.TK2MSFTNGP11.phx.gbl...
> Could it be that you for some reason didn't specify WITH RECOVERY for that
> last log restore? Try doing this using TSQL instead of EM (you can catch
the
> commands that EM sends with Profiler and then execute them in query
> analyzer. And make sure that you specify WITH RECOVERY for that last log
> restore.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
>
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "Dave" <shoad316@.hotmail.com> wrote in message
> news:78cf0572.0311110909.4a320140@.posting.google.com...
> > Hey all,
> >
> > I've been playing around with point in time recoveries and
> > encountered a weird issue. Some background info:
> >
> > I performed a full back, a differential and then some transaction log
> > backups. I made data changes at set intervals and I can recover to
> > points in time between those without any issue.
> >
> > Here's the problem... When you click on point in time recovery a
> > window pops up prompting you for a time. The default thats in there
> > appears to be the time of the last transaction log, so i'm assuming
> > that would be the maximum time you could restore to. If I click on
> > OK the restore proceeds and completes successfully. But, when I go
> > back to the EM console the database is marked as Loading and in the
> > logfile it says:
> >
> > Bypassing recovery for database 'myTest' because it is marked IN LOAD.
> >
> > If I repeat the process and do another point in time recovery but
> > select a time 10 seconds before the default time the database recovers
> > fine. If I do a full restore using the last transaction log it works
> > fine as well.
> >
> > I searched on google, technet, etc but no luck... I'm not overly
> > concerned but curious as to why the database isn't recovering
> > properly.
> >
> > Dave
>