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.

  • Please edit the question and describe what steps, exactly, you are taking when attaching the db is attempted.
    – vonPryz
    May 29 '18 at 5:34

Specify the path for every database file (including ldf file) and SQL Server will not look for the original path. If the GUI does something strange, then use the CREATE DATABASE ... FOR ATTACH directly (examples in the product documentation, for instance).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.