Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Restoring log

Author  Topic 

venkath
Posting Yak Master

202 Posts

Posted - 2006-11-02 : 03:56:01
Hi all

I have taken log backups at 10AM and 11AM

now can i restore the transactions upto 10:30AM..??

Thanks

mr_mist
Grunnio

1870 Posts

Posted - 2006-11-02 : 04:30:22
Set the point that you want to restore to in Enterprise Manager or use the STOPAT parameter with RESTORE LOG

-------
Moo. :)
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-11-02 : 04:36:59
Yes

See: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=RESTORE%20syntax%20/%20example

Kristen
Go to Top of Page
   

- Advertisement -