Solved

SQL database recovery

Posted on 2011-03-07
5
275 Views
Last Modified: 2012-05-11
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...
0
Comment
Question by:underIce
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
5 Comments
 
LVL 13

Accepted Solution

by:
Wizilling earned 500 total points
ID: 35063369
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
 

Author Comment

by:underIce
ID: 35063416
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
 

Author Comment

by:underIce
ID: 35063437
Wait, hold up....had to run as administrator.
0
 

Author Comment

by:underIce
ID: 35063525
Win. That's how much I'm not a SQL guy...easy as it gets, Thanks!
0
 

Author Closing Comment

by:underIce
ID: 35063530
Very good, thanks!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question