Post reply

Backup Process

  • January 24, 2005 at 5:43 am

    #92118

    Hi All,

    I have a question on database backup.

    Take for instance, we are taking a Full Database backup of a database.

    The backup process starts at 10:00 am and end at 10:30.

    I am curious at knowing that if all the comitted transactions which took place between the backuptime i.e. 10:01 and 10:29 are a part of the backup or no.

    I mean all the committed transactions become a part of backup file or it only backups up the committed transactions during a backup.

    Please throw more light on this topic.

    Thanks.

     

  • January 25, 2005 at 2:13 am

    #538896

    As far as I know, SQLServer 2000 keeps track of running transactions during a backup, and results of all transactions, committed before the backup ends, are written to the file.

    So, if the backup is running from 10:00 to 10:30, results of any statements committed at 10:29 should be part of the backup.

  • January 25, 2005 at 6:43 am

    #538930

    Yes, the backup process will record all the committed transactions in the full backup till 10:29.

    Only the uncommitted will not be written to the backup.

    regards,

    umesh



    Umesh Chaphekar

    --Every minute you waste someone gains on you ---

  • January 30, 2005 at 11:45 pm

    #539681

    Ok.You mean to say that if a trnsaction starts at 10:05 and ends at 10:20 will also be a part of the backup file.

    Thats great. I think I am clear now.

    Thanks All. 

  • January 31, 2005 at 2:00 am

    #539686

    Yaaa..

    u get all commited trans between

    10:00 to 10:30

    in fullbackup

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

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