Options

8.4.1.527 - Odd "Processed" quantity

PDinCAPDinCA Posts: 642 Silver 1
edited February 24, 2017 5:38PM in SQL Backup
DB has an mdf of 27.8GB, and an ldf of 13.6GB

Why does SQB tell me it has processed 33.7GB for a TRANSACTION Log backup?
Jesus Christ: Lunatic, liar or Lord?
Decide wisely...
· Share on Twitter

Comments

  • Options
    peteypetey Posts: 2,358 New member
    Could you please post the contents of the SQL Backup log for the backup process that reported those numbers? The default folder where the logs are stored is C:ProgramDataRed GateSQL BackupLog<instance name>, unless you're using Windows 2003 or older OSs, for which the default folder is then 'C:Documents and SettingsAll UsersApplication DataRed GateSQL BackupLog<instance name>'.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
  • Options
    PDinCAPDinCA Posts: 642 Silver 1
    For the life of me I can't find the DB/server combo I did this on.

    Will have to find another anomaly one day...
    Jesus Christ: Lunatic, liar or Lord?
    Decide wisely...
    · Share on Twitter
  • Options
    PDinCAPDinCA Posts: 642 Silver 1
    Anomaly found!

    The Log drive is full, so I know it cannot go greater than the current 832GB eaten.

    My snapshot of the UI states 956 GB processed thus far.

    A tad perplexing.

    Pity I can't attach an obfuscated image...
    Jesus Christ: Lunatic, liar or Lord?
    Decide wisely...
    · Share on Twitter
Sign In or Register to comment.