troubleshooting Question

Trying to restore .mdf file in SQL Server 2005 to different name than original database name

Avatar of alexisbr
alexisbr asked on
Microsoft SQL Server
11 Comments1 Solution936 ViewsLast Modified:
Hi.  I have been checking posts and trying different solutions but can't seem to figure this one out.   I have a backup of a sql server 2005 databases in mdf file format.  I do not have an ldf file.  I want to restore this mdf file to a different database name so I can review it and extract some deleted data that no longer exists in the live database.  But when I try to attach the file name, even though I have renamed the mdf file to the new name I want to use, the restore process sees the original database name and gives me an error "Cannot attach a database with the same name as an existing database".  Is there a way I can restore this mdf file originally created from database name mydb to new database name mydb052412?


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 11 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros