Can you Identify the sql server name from sql backup file(.bak)?
You could run a RESTORE HEADERONLY on the backup file to read the contents and get the ServerName column.

For example:

CREATE DATABASE BLABLA
GO

backup database BLABLA
to disk = 'c:\temp\BLABLA.BAK'

RESTORE HEADERONLY FROM DISK = 'c:\temp\BLABLA.BAK'


Result:



With the servername column being the one you want for the backup(s) residing in the backup file.