Backup & Restoration Script

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Ashish Gilhotra » Backup & Restoration Script

Backup & Restoration Script

Rate Topic

Display Mode

Topic Options

Author

Message

Ashish Gilhotra

Posted Thursday, September 10, 2009 3:34 PM

Valued Member

Group: General Forum Members
Last Login: Tuesday, February 12, 2013 10:05 PM
Points: 50, Visits: 41

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

Post #786053

mstjean

Posted Wednesday, September 16, 2009 10:25 AM

SSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 1:15 PM
Points: 423, Visits: 1,948

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

Post #789118

svedantam

Posted Thursday, July 01, 2010 12:17 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:00 PM
Points: 136, Visits: 132

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 )

Post #946390

« Prev Topic | Next Topic »

Permissions