May 28, 2003 at 2:37 am
Hi!
Trying to restore database by two hours before now state. Have a full DB backup two weeks old and a log backup made right now. Set STOPAT time at 10.00 AM
Get an error:
Invalid value specified for STOPAT parameter.
RESTORE LOG is terminating abnormally.
Restore FULL + LOG works fine, but I need it two hours ago.
May 28, 2003 at 2:44 am
I'm not sure if you're doing this in EM or Query analyzer, but there is a problem if it's the first restore your doing and you use EM. Check out this document, and believe me that the Service Pack doesn't always solve this.
M
[font="Verdana"]Markus Bohse[/font]
May 28, 2003 at 2:45 am
Oops, I forgot the place the link to the document.
http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b260182
[font="Verdana"]Markus Bohse[/font]
May 28, 2003 at 3:10 am
I am doing it in EM and this is the only log backup and I have SP3 for mai SQL2000.
So should I do this in query analyzer?
May 28, 2003 at 6:00 am
Thanks a lot, I managed to do this in QA
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply