After running the below script, I'm able to generate the script:

Script:

SELECT 'exec master.dbo.xp_restore_log

@Database=''WSS_Content_DB1'',

@filename=''Z:\Backups\VS1$ABCINS1\WSS_Content_DB1\LOG'',

@with = NORECOVERY,

@with =''STATS = 10'''

FROM [msdb]..[backupfile] bf

INNER JOIN [msdb]..[backupset] bs

ON bf.backup_set_id = bs.backup_set_id

WHERE database_name = 'WSS_Content_others' AND

bs.type = 'L'

AND backup_start_date > '20130630 13:45' -- adjust to the time of used FULL/DIFF backup

ORDER BY backup_finish_date

Generated Script:

I'm pasting only sample rows. I got too many rows.

Question:

Here, after the backup path (Z:\Backups\VS1$ABCINS1\WSS_Content_DB1\LOG), there are actual log backup files like "VS1$ABCINS1_WSS_Content_DB1_LOG_20130703_154617.lstrn". But our generated script does not have the actual log backup files in it. It generating until the log backup path not the actual log backup files. I did NOT see any use with out having the actual log flies. Please advise

exec master.dbo.xp_restore_log @Database='WSS_Content_DB1', @filename='Z:\Backups\VS1$ABCINS1\WSS_Content_DB1\LOG', @with = NORECOVERY, @with ='STATS = 10'

exec master.dbo.xp_restore_log @Database='WSS_Content_DB1', @filename='Z:\Backups\VS1$ABCINS1\WSS_Content_DB1\LOG', @with = NORECOVERY, @with ='STATS = 10'

exec master.dbo.xp_restore_log @Database='WSS_Content_DB1', @filename='Z:\Backups\VS1$ABCINS1\WSS_Content_DB1\LOG', @with = NORECOVERY, @with ='STATS = 10'

exec master.dbo.xp_restore_log @Database='WSS_Content_DB1', @filename='Z:\Backups\VS1$ABCINS1\WSS_Content_DB1\LOG', @with = NORECOVERY, @with ='STATS = 10'

exec master.dbo.xp_restore_log @Database='WSS_Content_DB1', @filename='Z:\Backups\VS1$ABCINS1\WSS_Content_DB1\LOG', @with = NORECOVERY, @with ='STATS = 10'

exec master.dbo.xp_restore_log @Database='WSS_Content_DB1', @filename='Z:\Backups\VS1$ABCINS1\WSS_Content_DB1\LOG', @with = NORECOVERY, @with ='STATS = 10'

exec master.dbo.xp_restore_log @Database='WSS_Content_DB1', @filename='Z:\Backups\VS1$ABCINS1\WSS_Content_DB1\LOG', @with = NORECOVERY, @with ='STATS = 10'

exec master.dbo.xp_restore_log @Database='WSS_Content_DB1', @filename='Z:\Backups\VS1$ABCINS1\WSS_Content_DB1\LOG', @with = NORECOVERY, @with ='STATS = 10'

exec master.dbo.xp_restore_log @Database='WSS_Content_DB1', @filename='Z:\Backups\VS1$ABCINS1\WSS_Content_DB1\LOG', @with = NORECOVERY, @with ='STATS = 10'

exec master.dbo.xp_restore_log @Database='WSS_Content_DB1', @filename='Z:\Backups\VS1$ABCINS1\WSS_Content_DB1\LOG', @with = NORECOVERY, @with ='STATS = 10'

exec master.dbo.xp_restore_log @Database='WSS_Content_DB1', @filename='Z:\Backups\VS1$ABCINS1\WSS_Content_DB1\LOG', @with = NORECOVERY, @with ='STATS = 10'

exec master.dbo.xp_restore_log @Database='WSS_Content_DB1', @filename='Z:\Backups\VS1$ABCINS1\WSS_Content_DB1\LOG', @with = NORECOVERY, @with ='STATS = 10'