if Full Backup Time and Trn Log Backup Time same?

  • i have taken a log backup with truncate only, the chain of log sequence break..

    but i nedd to take log backup with truncate..bac of log file size is full..

    Is there any way to truncate log file and sequence is not break?

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

  • Hello Paresh,

    Nice try to understand the SQL Backup.

    Just think one step ahead of and try to understand the internal mechanism...

    When full backup is running it is taking the snapshot of the Database i.e. captureing the all Datapages considering all the changes during the Full backup. Hence when you do have Full backup; you do have all the commited transaction till the Full backup completed. i.e. Here if you Fullbackup completed around 5:02am it contain all the commited transactions till 5:02am.

    Keep moving.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • Paresh Prajapati (12/8/2008)


    i have taken a log backup with truncate only, the chain of log sequence break..

    but i nedd to take log backup with truncate..bac of log file size is full..

    Is there any way to truncate log file and sequence is not break?

    No. The BACKUP LOG will invalidate completed transactions allowing the space to be reused. If you transaction log file has filled your disk, you can shrink the transaction log file using SSMS to shrink the log file.

    If the log file expanded to the point that it filled your drive, you need to see about moving it to a larger disk drive or increase the frequency of your transaction log backups.

  • Means Full backup also contain commited transactions, which are also commited in transaction logs which are backuped during Full backup.!!!

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

  • But the t-log backups will only have the transactions from entered since the last t-log backup.

    Is your disk drive filling up during the full backup?

  • Lynn Pettis (12/8/2008)


    But the t-log backups will only have the transactions from entered since the last t-log backup.

    Is your disk drive filling up during the full backup?

    disk drive filling up during the full backup in regarding what?

    MDF or BackupFile?

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

Viewing 6 posts - 31 through 35 (of 35 total)

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