I need to recover some specific table information and need to know how to attached a copy of a database. I restored the db from a backup, renamed it and then tried to attach it. I get the error: "Cannot attach a database with the same name as an existing
database. I have also renamed the log file. This database is SQL2005Express. The main database is on a webserver, so I didn't want to restore it. I need to open the backup and then extract some information from it.
Thanks for any help!
View Complete Post