Resolution: Rename the database "WSS_Search_MIG" to some other name. SharePoint is trying to create a new search database and find the file already exists so its not able to overwrite the schema of that database.
And start the Search Service from Central Administration -> Operations -> Services on server -> Click on the Windows Sharepoint Services Search service.
