SQL database recovery
Posted on 2011-03-07
I have an application that writes data into a SQL database. Last week, a laptop crashed and had to be rebuilt. I was able to recover the .mdf and .ldf files but the application dooesn't have any allowance for an import.
So I have a database that I can't get data out of.
What options do I have? It's runs on SQL 2005 and I have the managment studio installed. But I'm not a SQL expert.
I might be fine with getting the data into an Access database or even written to an XML file.
If there's a way to inport the data into the new application database that would be the best solution to this. I should also note that there doesn't seem to be any sa password setup during the install, the only username/password requested is during the setup of the application itself.
Also, SQL is installed during the application install and isn't a preexisting install...