cancel
Showing results for 
Search instead for 
Did you mean: 

MSSQL restore transaction log

sakurai_tabi
Level 3

How to restore all the transaction log without specifying point-in-time option ? Just like

restore log <databasename> from disk='<path>' with recovery 

Capture.JPG

2 REPLIES 2

sdo
Moderator
Moderator
Partner    VIP    Certified

Does this provide you with any guidance?

Options for NetBackup for SQL Server restores

https://www.veritas.com/support/en_US/doc/17221771-126559330-0/id-SF930873572-126559330

Michal_Mikulik1
Moderator
Moderator
Partner    VIP    Accredited Certified

Hello,

when you restore all transaction logs, IT IS without point-in-time option.

Tha date/time you see on the restore screen, is not taken into account when you dont configure it. In such case it just shows you from which date/time is the last transaction in the last transaction log.

Regards

Michal