Transaction Log vs restore at a specific point in time 
Author Message
 Transaction Log vs restore at a specific point in time

With SQL 6.5, If I want to restore a transaction log at a specific point in
time, do I have to dump the log every minutes or I can dump it every hours
and then restore de log to the specific point in time.

Full Backup at 00h00
Dump Transaction at 01h00
Dump Transaction at 02h00
Dump Transaction at 03h00
Dump Transaction at 04h00
Dump Transaction at 05h00
etc...

I want to restore de log to have de DB in the same state it was at 02h48
(and, if it's possible,  02h48s37)

Can I do it

Thanks

Eric Perron



Fri, 27 Dec 2002 03:00:00 GMT
 Transaction Log vs restore at a specific point in time

Eric - yes you can, just look at the LOAD TRANSACTION syntax in BOL.

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please reply only to newsgroups)
 SQL FAQ (484 entries) see
 forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps (faqrtf.zip - L7
- SQL Public)
 or www.ntfaq.com/sql.html
 or www.sql-server.co.uk
 or www.mssqlserver.com/faq



Fri, 27 Dec 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Restoring Transaction Logs -Point-in-time recovery is inhibited

2. Point in Time restore from transaction log

3. Restoring to a Point in Time vs last Tran Log Dump

4. URGENT: How to restore to the point of failure (How to apply the current transaction log)

5. Point in time restore (LOAD TRANSACTION WITH STOP AT) fails

6. Please help...Backup vs Transaction log vs Restore is so important

7. Please help...Backup vs Transaction log vs Restore is so important

8. Restoring database to certain point of time ( Before to a certain transaction)

9. Restore DB from transaction log to specific date

10. restore log to a point of time

11. Point in Time Recovery from Transaction Log?!

12. send specific oracle 8i table data to specific sql server 2000 table at specific times


 
Powered by phpBB® Forum Software