How to take Transaction Log backup ? TIP# 68

 

As we discussed in earlier tips how to take full backup and differential backup now in this tip we will see how to take transaction backup .

Before taking transaction backup the first and mandatory condition is that you should have a full backup.

Just right click the database and go to backup option as you will get following screen. Now we need to select Transaction Log   option in   backup type dropdown.

Once this is selected we need to give a transaction log backup name as shown below. The extension should be .TRN

 

TransactionalBackup

 

Once you provided all the mandatory values just click on then you will get your  Transaction Log backup.

We can take Log backup with  SQL command also

For example :-

BACKUP LOG IndiandotnetDB
TO DISK =’E:\IndiandotnetTransaction.trn’

When you run above command you will get following screen and your log backup is done.

Transaction_Log_by__command

I hope this will help you.

Thanks & Enjoy!!!

RJ!!

Advertisements

One thought on “How to take Transaction Log backup ? TIP# 68

  1. Rajat, Can you please be more specific for below statement?

    “Before taking transaction backup the first and mandatory condition is that you should have a full backup. ”

    Do you mean that we need to take full backup first and then transaction back up and same thing is also applied for differential backup (mentioned in your previous post)

    Thanks
    Nutan Patel

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s