faisalfarouqi (8/13/2014)
What if I delete the file entry from sys.master_files..will that help
The system tables cannot be edited. Edit: And even if they could, the DB is not online, so you wouldn't be able to get at the system tables which underlie sys.database_files to change them. Not to mention that, since those files have to be part of PRIMARY to be giving this kind of errors, the missing files will include parts of the system tables, so the DB doesn't have a chance in hell of coming online without them.
Get out your latest backup and restore it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability