San-847017 (10/15/2009)
If you leave out either step 1 or step 3, the DB will be suspect when it's brought online.
Gila, Infact it's not coming online at all. Getting the error saying "Unable to open physical file...."
Correct, it cannot come online.
It doesn't leave the DB in the offline state, doesn't put it online. In fact (if you check the sys.databases view) the state of a DB after doing this is RECOVERY_PENDING. Not actually the SUSPECT state, but it means almost the same thing.
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