如何在不知道目标路径或文件名的情况下还原SQL Server数据库备份？

I need to programmatically (T-SQL) restore a database backup in SQL Server 2008. This backup comes from a different server and the original database name may have been different as well. (In effect, I am copying a database from some server to a new database on another server.)I need to programmatically (T-SQL) restore a da