SQL database recovery

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...
underIceAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
WizillingConnect With a Mentor Commented:
you need to attach the mdf and ldf files in management studio.

http://msdn.microsoft.com/en-us/library/ms190209.aspx

http://www.youtube.com/watch?v=OLuciwUZCv0
0
 
underIceAuthor Commented:
When I try that I get this error:
TITLE: Microsoft SQL Server Management Studio Express
Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
The server principal "BH-PC\BH" is not able to access the database "model" under the current security context. (Microsoft SQL Server, Error: 916)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.4035&EvtSrc=MSSQLServer&EvtID=916&LinkId=20476

This error happens right after I select the add button in the Attach Database dialog box...
0
 
underIceAuthor Commented:
Wait, hold up....had to run as administrator.
0
 
underIceAuthor Commented:
Win. That's how much I'm not a SQL guy...easy as it gets, Thanks!
0
 
underIceAuthor Commented:
Very good, thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.