Trying to restore .mdf file in SQL Server 2005 to different name than original database name
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?