File id xx was expected but xx was read from Verify that files are mapped correctly in sys.master_files. ALTER DATABASE can be used to correct the mappings.

 

Error:-

An unexpected file id was encountered.

 File id xx was expected but xx was read from 

Verify that files are mapped correctly in sys.master_files. ALTER DATABASE can be used to correct the mappings.

Database:-SQL Server any version.

Reason: - While relocating the database file, mentioned the incorrect the data files name.

Solution:- Start the database in emergency mode and execute the database file relocation with correct name and path and restart the database with multi user access.