Sample Header Ad - 728x90

Detached database with renamed drive

0 votes
1 answer
70 views
I have detached a database and had the systems team rename the drive letter (from E: to P:). When I try to attach the database again, it's looking for the original drive. I don't have a backup of the database. Is there any way I can change the system tables where the actual physical locations of the files (.mdf) are stored? Are there any alternative solutions now? Just to be clear: It's my mistake that I approved the systems team to change the drive letter.
Asked by yvr238 (129 rep)
May 29, 2018, 03:18 AM
Last activity: May 29, 2018, 07:46 AM