Point in time restore problems

I have some problems using point in time restore. I use SQL 2000 SP3a on a W2000 server. I use the full recovery option. I start the week with a full backup and every 3 hours I take a log backup.
If I use the ''Point in time restore'' option, at the end of the restore, my database is ALWAYS in ''Loading'' state even if I checked the ''Leave database operational''. I know that I can use the ''RESTORE DATABASE XXX with recovery'' to bring it in normal mode but if I use this command every logs are restored and the date and the hour that I put in the ''Point in time restore'' is useless. The other thing that bug me is even if you put something in ''Point in time restore'' option, SQL doesent seem to take care of and it restore simply every backup and logs that are checked in the list in the bottom of the ''Restore database'' screen.
I use ''Point in time restore'' a lot in the SQL 7.0 but it's the first time in SQL 2000. Something change ?Could it be that the 'point in time' that you were trying to restore upto,
is later than the time period covered by the last log you restored?
I don't use Enterprise Manager for restoring or backing up databases, so I
cannot comment on their usability aspects.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"Cris" <anonymous@.discussions.microsoft.com> wrote in message
news:F563BD78-B7C7-4BAA-8613-D1771338D88B@.microsoft.com...
I have some problems using point in time restore. I use SQL 2000 SP3a on a
W2000 server. I use the full recovery option. I start the week with a full
backup and every 3 hours I take a log backup.
If I use the ''Point in time restore'' option, at the end of the restore, my
database is ALWAYS in ''Loading'' state even if I checked the ''Leave
database operational''. I know that I can use the ''RESTORE DATABASE XXX
with recovery'' to bring it in normal mode but if I use this command every
logs are restored and the date and the hour that I put in the ''Point in
time restore'' is useless. The other thing that bug me is even if you put
something in ''Point in time restore'' option, SQL doesent seem to take care
of and it restore simply every backup and logs that are checked in the list
in the bottom of the ''Restore database'' screen.
I use ''Point in time restore'' a lot in the SQL 7.0 but it's the first time
in SQL 2000. Something change ?