'(There's) no such thing as a stupid question' is a popular phrase that has had a long history. It suggests that the quest for knowledge includes failure, and that just because one person may know less than others they should not be afraid to ask rather than pretend they already know. :)
I am using below code to transfer full backups to another location using XCOPY:
similarly you can modify and transfer the file from required path to another server.
DECLARE @RowCnt INT
SELECT bs.database_name AS DatabaseName,
MAX(bms.physical_device_name) AS FullBackupName
INTO #Backups
FROM msdb.dbo.backupset bs
INNER JOIN msdb.dbo.backupmediafamily bms
ON bs.media_set_id = bms.media_set_id
INNER JOIN master.dbo.sysdatabases s
ON bs.database_name = s.name
where datepart(yyyy,backup_start_date)=datepart(yyyy,getdate())
and datepart(dd,backup_start_date)=datepart(dd,getdate())
and datepart(mm,backup_start_date)=datepart(mm,getdate())
and bs.type='D'
GROUP BY bs.database_name
SET @RowCnt = @@ROWCOUNT
WHILE @RowCnt <> 0
BEGIN
SELECT TOP 1 @DBName = DatabaseName, @BkpFileName = FullBackupName
FROM #Backups
ORDER BY DatabaseName
SET @RowCnt = @@ROWCOUNT
IF @RowCnt <> 0
BEGIN
SELECT @SQL = 'xcopy ' + @BkpFileName +SPACE(1)+ '\\your\path\tobackup\'
EXEC master.dbo.xp_cmdshell @SQL
--print @sql
DELETE FROM #Backups
WHERE DatabaseName = @DBName
END
END
DROP TABLE #Backups
SET NOCOUNT OFF
Ps note: You have to make sure XP_Cmdshell is enabled for above to work!