Just run sp_who2 and look for the entries with DBName the same as the database you want ot restore. For a resource, always start out in the Books Online (BOL).