I have a .mdf file which contains more than 30 GB data. On trying to attach this to SQL on one of our standalone dev servers (with independent database), I am getting the following error message :
"Attach database failed for Server 'xxx'
Additional Information: An exception occurred while executing a Transact-SQL statement or batch. Could not open new database 'xx'. CREATE Database is aborted. File activation failure. The physical filename "....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."
The problem here is we don't have the .ldf file and on trying to attach the .mdf file we are getting the above error message. Is the content db corrupted? if so is there any way by which we can only restore the content DB in SQL, since we don't have another copy and only this file?