how to check whether the backup files exists in a network drive with modified dates

Question

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

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

umasingh Ten Centuries Points: 1182 More actions · Answer 1

Here is the query

DECLARE @Tbl AS TABLE (Details VARCHAR(MAX))

DECLARE @FilePath AS VARCHAR(100) = '\\NWDrive\FolderName\'

DECLARE @Cmd AS VARCHAR(100) = 'DIR ' + @FilePath

INSERT INTO @Tbl

exec master..xp_cmdshell @Cmd

SELECT Details,LEFT(Details,20) LastModifiedOn

FROM @Tbl

a.vikramsimhareddy Grasshopper Points: 18 More actions · Answer 2

Grasshopper

Points: 18

January 25, 2012 at 12:36 am

Thank you, it really works for me.

umasingh Ten Centuries Points: 1182 More actions · Answer 3

Ten Centuries

Points: 1182

January 25, 2012 at 1:02 am

welcome 🙂