prettsons (3/12/2014)
You need to remove the suspect mode from the server first then you can attach the database.
No.
Suspect is a status that a database has, not a server and it's a smidgen hard to remove the suspect status from a database before it's attached.
And as always recommending repair with data loss before even looking at the details of the corruption is a bad idea.
4 month old thread, so I suspect the OP has resolved it one way or another
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