Post reply

Find size of the device or the backup file

  • May 6, 2009 at 5:44 am

    #200178

    Hi,

    I have got 3 servers.

    1 live ,1 hot, 1 cold

    Every 15 mins a job is made that the transaction log file gets updated and then its moved into the other 2 servers.

    We are using devices in all the servers.

    I want to know the size of the backup file size everytime when its send to the 2 servers.

    The backup file stays in the Live server and then via job, jobs of the other 2 servers are started.

    Can somebody help.

    I need to know when the backup files are ready and are started what is the size of the backup file. I need to sotre it in a table.

    Thanks

    Harsha

  • May 7, 2009 at 7:03 am

    #990314

    You can query msdb.dbo.backupset for this.

    It contains a column backup_size which will give you the size in bytes.

    [font="Verdana"]Markus Bohse[/font]

  • May 7, 2009 at 9:36 am

    #990437

    Hi,

    I searched for the name but culdnt identify which one should i look for. If i look for the differential file then i get the file but its not the correct one. Does this have the backup devices name??

  • May 7, 2009 at 9:58 am

    #990457

    Thanks a lot. That solved my problem.

    Thanks a lot.

    Harsha

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

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