Post reply

BackUp

  • October 12, 2008 at 1:15 am

    #194297

    I am new in sql server so I have a problem with backup, i like to know the type of back up and why transaction back is different from differential backup???

  • October 12, 2008 at 9:02 am

    #883896

    Please don't post polls for questions. Use Add Topic.

    This is covered in books online. For general questions, please do some research.

    http://msdn.microsoft.com/en-us/library/ms175477.aspx

  • October 23, 2008 at 3:02 pm

    #888896

    Good Poll topic dude..I wouldn't wanna vote before Nov 4th though :hehe:

    Ok, quick answer to your question:

    Differential backup has all the changes made to your database since the time there was a FULL backup.

    Transaction Log backups ( say T1,T2,T3) : T2 has changes made since T1 and T3 has all the changes made after T2..so if you are required to restore Transaction Logs, you would have to restore full backupp and then go the T1 then T2 and then T3 way..

    Instead if you take a Differential backup at T3 then you would only require to restore T3 after the full backup restore.

    Thanks!!

    The_SQL_DBA
    MCTS

    "Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

  • October 28, 2008 at 3:42 pm

    #890952

    Differential backup backs up all the changes since the last full backup.

    Transaction log backup backs up all the changes made since the last transaction log backup, or since the last full backup if there is no previous transaction backup.:cool:

  • October 29, 2008 at 1:09 am

    #891059

    Thanks for all... i got the answers....

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply