[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

SQL database recovery

Posted on 2011-03-07
5
Medium Priority
?
290 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
  • 4
5 Comments
 
LVL 13

Accepted Solution

by:
Wizilling earned 2000 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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

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

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses

607 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