We can use the RESTORE and WITH RECOVERY statements in SQL to recover a database log in SQL Server.
The following syntax recovers from a BACK file to SampleDB.
RESTORE LOG SampleDB
FROM DISK = 'E:\SQLBackups\SampleDBbackup.BAK'
WITH RECOVERY
How to recover a database log in SQL Server
2 Comments
Join the conversation! Your thoughts help the community grow.
Sign in to leave a comment
It is the same account you read, post and publish with — and you will come straight back to this page.
Alex KrenvalkPosted Mar 31, 2012, 12:21 PM
<a href="http://www.recoverytoolbox.com/sql.html">sql database recovery</a> allows you to save critical data and avoid losing it. Tool recovers System Tables and User Tables, Stored Procedures, Views, User Defined Data Types and Functions. It works with big databases more than 16TB. Application doesn't modify source database file.
Alex KrenvalkPosted Mar 3, 2012, 1:52 PM
http://www.recoverytoolbox.com/sql.html allows you to save critical data and avoid losing it. Tool recovers System Tables and User Tables, Stored Procedures, Views, User Defined Data Types and Functions. It works with big databases more than 16TB. Application doesn't modify source database file.