point in time restore error

When i use point in time restoration, it show error STOPAT , restore og
terminates why? and i can restore it without use point in time restoration!Please post the full text of the error.
Nik Marshall-Blank MCSD/MCDBA
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:9683A6B5-4609-450F-BC21-AD123E4DE8F3@.microsoft.com...
> When i use point in time restoration, it show error STOPAT , restore og
> terminates why? and i can restore it without use point in time
> restoration!|||Hi,
STOPAT can be used in transaction log backup and only if your source
database is in FULL RECOVERY MODEL.
See the recovery model of your source database first.
The actual syntax is:-
-- Restore the database backup.
RESTORE DATABASE MyNwind
FROM MyNwind_1, MyNwind_2
WITH NORECOVERY
GO
-- Restore the log backup with stopat option
RESTORE LOG MyNwind
FROM MyNwind_log1
WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
GO
Thanks
Hari
SQL Server MVP
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:9683A6B5-4609-450F-BC21-AD123E4DE8F3@.microsoft.com...
> When i use point in time restoration, it show error STOPAT , restore og
> terminates why? and i can restore it without use point in time
> restoration!