I am wonder what the process would be to recover from a lost data file in MSSQL. Up front this is a hypothetical situation but lets say that there is no backups available and a data file from a database in question is completely corrupted/deleted/vaporized :) . This could be simulated by stopping the sql service, renaming the file and then restarting the service. The database is then put into recovery pending mode and is not able to come back online because it cannot find the file. I am under the assumption that if this is the primary database file you are probably hosed. However if this is a secondary data file I can imagine that there is a way to force the database online. I am not concerned with the loss of data that will be involved but more concerned with how this can be performed.
What you're talking about is called a piecemeal restore. It's actually only available when using the Enterprise version of SQL Server. You can get an introduction to the topic here in [Books Online]. Probably, in many situations, you're just out of luck and will probably not get that database back online. :