SET NOCOUNT ON

DECLARE @SQL VARCHAR(7000)
DECLARE @DBName SYSNAME
DECLARE @BkpFileName NVARCHAR(260)

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 	CONVERT(VARCHAR(20), bs.backup_finish_date, 101) = CONVERT(VARCHAR(20), GETDATE(), 101) AND
      	s.name NOT IN ('master', 'msdb', 'model', 'pubs', 'Northwind')
GROUP BY 
	bs.database_name

WHILE (SELECT COUNT(*) FROM #Backups) <> 0
BEGIN

	SELECT  TOP 1 @DBName = DatabaseName, @BkpFileName = FullBackupName
	FROM	#Backups
	ORDER BY DatabaseName
	
	SELECT @SQL = 'xcopy ' + @BkpFileName + ' \\SomeServer\Someshare\'

	EXEC master.dbo.xp_cmdshell @SQL

	DELETE FROM #Backups
	WHERE DatabaseName = @DBName

END

DROP TABLE #Backups