Cannot attach a database mdf extension missing also no ldg file
Trying to attach a database that I had previously uploaded to AWS s3 bucket using the cli sync cmd and noticed that I had failed to upload the lgd and that the mdf extension is missing. I downloaded the database and tried to attach it and received this message "The file you have specified is not a valid SQL server database file. I tried adding the .mdf extension but the results are the same. The file looks to be the correct size as I have another copy about a week old and they are close to the same size I am rebuilding a crashed server and it would be nice to have the more recent file. The older copy was also on AWS s3 and it had the mdf extension and the ldg file and it attaches with no issues Any help with how to fix this will be greatly appreciated.
I was rebuilding a crashed server and I tried restoring the databases again and they indeed were backup files. I believe the first time I tried to restore I had not attached an older copy and the restore failed but after attaching the older databases the restore worked Don't send a boy to do a man's job! Thanks for helping!
The file-extension is only for humans, not for MSSQL. You can create a datafile with every extension you want (but this is not advisable). To summarize your problem: you can attach the database within AWS, but not to a local MSSQL intance?