We restored the database in the client development server for out client development and testing purpose.This time we need to take back and restore it in the client production machine. while am doing this we are unable to restore it. Later we found in client development machine client move the ‘.mdf and .ldf’ to different folder.
SELECT name, physical_name AS current_file_location
The above SQL script helped us to sort out the issue. We can also use this same script to clean up the junk database folder.