MyTechMantra.com
Connect With MyTechMantra.com

Like Us on Facebook    Follow Us on Twitter     Subscribe to our Feeds     Subscribe to NewsLetter

















Latest SQL Server Tips










TRANSACTIONAL LOG Backups in SQL Server Step by Step Tutorial with Examples

Read Comments   |   Related Tutorials: SQL Server Database Backup Options > Next Topic: COPY ONLY Backups

Page 10 / 16


Click here to read this tutorial from the beginning...

Introduction

Transactional log backup is only possible when your database is in FULL or BULK-LOGGED recovery model. With the help of Transactional Log backup one can achieve Point in Time recovery for the database in case of any disaster It is highly recommended to perform transactional log backups at regular intervals to minimize the loss of work and to truncate the transactional log.

Create a TRANSACTIONAL LOG Backups Using TSQL commands

BACKUP LOG MyTechMantra
TO DISK = 'C:\DBBackups\MyTechMantra.TRN'
WITH NOFORMAT, NOINIT,
SKIP, NOREWIND, NOUNLOAD, COMPRESSION, STATS = 25

/* Verify the Database Backup File Once the Backup has completed successfully */

RESTORE VERIFYONLY
FROM DISK = 'C:\DBBackups\MyTechMantra.TRN'
GO

Create a TRANSACTIONAL LOG Backup Using SQL Server Management Studio

  • Open SQL Server Management Studio, connect to the appropriate SQL Server Database Instance, in Object Explorer, click the SERVER NAME to expand the server tree.

  • Expand Databases node and then right click the database which you want to take a transactional log backup.
  • Select Tasks, and then click Back Up… option as shown to open up Back Up Database dialog box.
  • Select Backup Type as Transactional Log and Select Destination as Disk

  • Click on Add button to add a backup file and specify the backup file name and click OK to save the changes
  • Finally to take Transactional Log backup click OK

Create a TRANSACTIONAL LOG Backups Using TSQL commands in SQL Server


Clicking Next Page button to continue reading the topics and click on the Previous Page button to revisit the previous topic.

Previous Page.. Next Page..


Learn More...




Last Updated On: Feb 12, 2014



Share this Article



Receive Free SQL Server Tips and Keep Learning
Get Free SQL Server Tips




Please leave your Valuable Comment or Let us know how this article helped you: