I am trying to attach a .mdf
database file to a SQL Servre 2005 however we do NOT have the .ldf
and have been unsuccessful in all our attempts to date. I should also mention there is no back-up to pull from in this case.
Here is what we have tried to date:
Tried the below which created the Database and the Log file, however none of the data was there.
We also tried the below however this does not seem to work in 2005.
Any other suggestions?
How we got into this predicament
We moved our SQL Server to a new server machine and moved to a more current version. We detached all databases successfully (with no errors), moved things over and successfully reattached on the new server. Upon doing so we noticed that one of the databases did not get attached. Upon further inspection we noticed that the .ldf
file was on the NAS where it ought to be. We searched our entire network, but it is just nowhere to be found. Using the above steps we've tried attached the .mdf and created a new .ldf
however when one goes to the database it is empty eventhough the .mdf
is 730,624KB
CREATE DATABASE ... FOR ATTACH
. What errors you get when you attempt to attach the mdf ?