shahtisaipur (8/21/2014)
the error is myfile.mdf is not a primary database file. (SQL server , error 5171)
With that error, restore from your last good backup. That error suggests that the file header page is damaged, that's not repairable and can't be worked around.
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