log file | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

log file

Dear 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. _________
Satya SKJ
]]>