DECLARE @sql NVARCHAR(MAX),
	@originalInstance sysname,
	@OriginalName sysname;
	
SET @originalInstance = CAST('production' AS sysname);
SET @originalname = CAST('warehouse' AS sysname);


	SET @sql = '
	SELECT * 
	INTO #Backups 
	FROM OPENQUERY(' + QUOTENAME(@OriginalInstance) + ', ' + QUOTENAME('
	SELECT 
		a.backup_start_date,
		a.backup_finish_date,
		c.file_type,
		c.logical_name,
		c.physical_name,
		b.physical_device_name,
		a.position
	FROM 
		msdb.dbo.backupset a WITH (NOLOCK)
	INNER JOIN
		msdb.dbo.backupmediafamily b WITH (NOLOCK)
		ON a.media_set_id = b.media_set_id
	INNER JOIN
		msdb.dbo.backupfile c WITH (NOLOCK)
		ON a.backup_set_id = c.backup_set_id
	WHERE
		a.database_name = ' + QUOTENAME(@OriginalName, '''') + '
		AND
		a.backup_set_id >=
			(
			SELECT MAX(d.backup_set_id)
			FROM msdb.dbo.backupset d
			WHERE 
				d.TYPE = ' + QUOTENAME('D', '''') + '
				AND 
				d.database_name = ' + QUOTENAME(@OriginalName, '''') + '
				AND
				d.backup_finish_date IS NOT NULL
			)
		AND
		c.backup_size > 0
		AND
		a.backup_finish_date IS NOT NULL
	ORDER BY
		a.backup_set_id, c.file_type;', '''') + ');
	
	SELECT * FROM #Backups;
	';
		
select @sql;