10-13-15, 13:25 #1Registered User
- Join Date
- Oct 2015
Unanswered: Error 5120 when trying to attach to a database mdf file
I copied database .mdf and trying to attached to sql 2012 server but it gives error as attached
1. added user everyone with full control
2. coping .mdf in sql server default data folder
running sql studio manager in adminstrator
Need to solution to attached
10-13-15, 14:55 #2Resident Curmudgeon
Provided Answers: 54
- Join Date
- Feb 2004
- In front of the computer
There are multiple problems illustrated in your picture, not just one.
First and most important, NEVER put database files on the boot/system drive of a server. This is a reciepe for disaster!
Your options are ONLY ONE of:
- Move the MDF and LDF files for this database so that they are in the folder with your other MDF and LDF files.
- Move the "Elsteel India SQL" inside of the SQL Server data folder
- Move the "Elsteel India SQL" to another drive (D: is the most likely).
The first two will fix the Error #5, and the third ought to either fix it or make it easier to fix.
-PatPIn theory, theory and practice are identical. In practice, theory and practice are unrelated.