How to recover a database log in SQL Server

Karthikeyan Anbarasan
12y
2.6k
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

How To Shrink Database Log File In Sql Server

Ebook Download

View all

SQL Server 2012 Functions Recipes

Read by 5.5k people

Download Now!

Learn

View all