John Mitchell-245523 (1/8/2013)
It will depend on whether the database was cleanly shut down - it's possible that the files will be corrupt otherwise.
That's attaching without the log file. When you have both files, doesn't matter if SQL was cleanly shut down or not.
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