How to recover a database log in SQL Server

Karthikeyan Anbarasan
12y
3.7k
0
0

Blog

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

This blog shows on how to recover the database log with Recovery

Up Next

Recover Deleted Data On SQL Server

Ebook Download

View all

Introducing Microsoft SQL Server 2016

Read by 11k people

Download Now!

Learn

View all