muhammad.raza (5/17/2010)
Upon Attaching The Database it Gives Me Error : "THE FILE You Have Specified Is not Valid SQL Server Datbase File"
You sure it's a mdf file? If you're getting that error and it really is a SQL database file, there is no way you're going to attach it.
Can you explain exactly what you did to get to the point of trying to rebuild the log? Again, if that fails, there's usually no alternatives as it is the last resort.
The DB being 500GB is absolutely no excuse for no backups. External drives are not that expensive and I'm sure the complete loss of the entire database is going to cost a fair bit more than a couple extra drives
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