• You would use RESTORE HEADERONLY, RESTORE FILELISTONLY to verify if the Backup file belongs to that particular database and to check the original location of the database file. Optionally you can run RESTORE VERIFYONLY on the backup file to verify its validity.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga