Backup

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 …

How to take differential backup ? TIP #67

Friends,We were discussing backup from last few post. Now lets take a look one more feature of backup which is differential backup.Differential backup  is backup after last full backup. Before taking Differential backup  it is a mandatory condition to take full backup.Differential backup can speed up your recovery process or we can say restore process.In …

Oh! I forgot When I took last Database Backup ? How to determine this? TIP # 66

  In last few tips TIP #64 & TIP #65  we get information  how to take backup & How to ensure it can be restore? Now lets me share some more information related to backup. Problem:-   Sometimes , we are interested to know when last backup is taken for particular database ? Solution:  The first …

How to take compressed backup in SQL Server TIP #64

Problem:-  A good maintenance plan always said to take backup but sometimes it is very difficult to take backup of database just because of space constraint.We take backup but we don’t have enough space available.Solutions:  SQL server provided  the best way and gave us solution of compressed backup. Now how to take compressed backup let …

How to determine when Last backup taken of a database n SQL Server? TIP #15

Sometime we require to know when we have taken last backup. So let me share here all the backup, log shipping related detail you can find in the MSDB database which is system database.SQL server maintain all the backup related detail in the MSDB database table As Show in the figure Now we can run …