SQL Server Performance Forum – Threads Archive
log fileDear All, I’d i restore database using log file? Rajendar ok
You restore the database using first a full backup. Then last diff backup if you have one.
Then the transaction log backups and last, the current transaction log. All except the last should be restored with NORECOVERY so that open transaction will not rollback. The last would be restored WITH RECOVERY. Bambola.
By using RESTORE LOG…. refer to BOL for more information. _________