One table in my current database needs to be restored. I have a backup of my database (.bak) from last week that I would like to restore to a new database so I can then extract the table. When I try to restore the backup, it says that the .mdf cannot be overwritten. It is being used. Use WITH Move to identify a valid location for the file.. It says the same for the .ldf file.
How do a get a copy of the database from the .BAK so I can get the information from this one table?