Post reply

Backup & Restoration Script

  • September 10, 2009 at 3:34 pm

    #214374

    Comments posted to this topic are about the item Backup & Restoration Script

  • September 16, 2009 at 10:25 am

    #1054588

    Your elapsed minutes calculation is wrong (plug in an elapsed time exceeding 1 hour to see). Change old to new as shown below

    --old

    --cast(datediff(ss,BS.backup_start_date,BS.backup_finish_date)/60 as varchar(10))

    --new

    cast((datediff(ss,BS.backup_start_date,BS.backup_finish_date)/60) - (datediff(ss,BS.backup_start_date,BS.backup_finish_date)/3600) * 60 as varchar(10))

    Cursors are useful if you don't know SQL

  • July 1, 2010 at 12:17 pm

    #1187840

    The following formats the duration in HH:MI:SS.

    CONVERT( VARCHAR(8), DATEADD( SECOND, DATEDIFF( second, s.backup_start_date, s.backup_finish_date ), 0 ), 114 )

  • May 12, 2016 at 7:43 am

    #1878642

    Thanks for the script.

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

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