How to Manually Take Transaction Log backup of a database in SQL Server - SQL Server DBA Tutorial

This video illustrates how to take Transaction Log backup (T-Log) of a database in sql server 2005, 2008, 2012 and 2014 using SQL Server management studio as well as using T-SQL script. It shows step by step going through different options of the T-Log backup such as General, media option and Backup options. You will learn how to verify Transaction Log backup and perform check-sum before writing to the media.


Scripts used in this video:

BACKUP LOG [SalesOrders] TO  DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLPROD\MSSQL\Backup\SalesOrders_Tlog.bak' WITH NOFORMAT, NOINIT
 NAME = N'SalesOrders-Full Database Backup', SKIP, 
 NOREWIND, NOUNLOAD,  STATS = 10
GO




Manually Take Transaction Log backup of a database in SQL Server