unable to attach sql database

Carlos kambui

8y1.1kSQL

when i try to attach my mdf file i got below error have tried few ways like running my sql as Admininistrator,giving the full access of mdf file but yet not able to attach

error

An error occurred when attaching the database(s).Click the hyperlink in the message column for details

kindly assist to sort the error

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke8y ago
Where did you get these files from? Did you detatch the database before you copied the files over at the source server?

From the error message, it appears that the .mdf and .ldf are not consistent.
Carlos kambui8y ago
have both in same location
Nitin Sontakke8y ago
You must have both the .mdf and the .ldf files. Did you get BOTH from where you took it or just one?
Carlos kambui8y ago
File activation failure. The physical file name "C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\SBITPOS_log.ldf" may be incorrect.
The log cannot be rebuilt because there were open transactions/users when the database was shutdown, no checkpoint occurred to the database, or the database was read-only. This error could occur if the transaction log file was manually deleted or lost due to a hardware or environment failure.
the error i get
Francis Bastin8y ago
Copy your mdf file and paste it where your sql installed folder.
Final folder name is data
Nitin Sontakke8y ago
You will need to click the hyperlink - as messages says, and then post the error. You haven't posted the actual error.