recovery a SQL Server db from mdf/Ldf files

Hot Topic

Query with another query input parameter
Questions about "Dimension Processing Destination" & "Analysis Services processing Task"
Visual C++ 2005 (C++/CLI) - Newbie with ADO
The best Data Transformation tool to Update/Insert
Messages in the sys.transmission_queue for a disable queue
Display Vlaue
Sum on conditional Values
Creating a dynamic excel file
Using Forms Authentication with the Report Viewer control and SQL Server Reporting Services 2005
SQL Server 2005 machine reboots during backup or DBCHECK

SQL Server

Select GetDate() Just the month or year
Why SELECT AVG(column) From Table is not working in Jet database?
Can a non-admin user generate a create database script?
Full-Text Search gets syntax error and kills the transaction
Can i host a SQL2005 EE DB on SQL2000 engine ?
Creating Pull Subscription using T-SQL
If...Else..Statement
concatinating string values from multiple rows
SQL 2005 and ADO.NET 1.1 compatibility
ReportViewer 2005 InValidOperationException

recovery a SQL Server db from mdf/Ldf files

hi to all,

I'm newbie with Sql Server,

I've a serious problem. After a crash of one of my disk I loose all the data about the SQL Server db but I've the mdf and ldf files because were placed on another hard disk different from the SQL Serve Installation disk. I reinstalled the Sql Server (in a new path, a new hard disk letter) but I don't know how to rebuild the db starting from the mdf/ldf files. Is it possible

Please help me, I'm in a ugly Situation.




Answer this question

recovery a SQL Server db from mdf/Ldf files

  • Are Haugsdal

    Open Books Online. Do a search for Attach. It will have instructions and sample code.

  • Deicide

    What version are you using...SQL Server 2000 or 2005



  • vtortola

    If you can access the mdf/ldf files, simply doing an attach will do the trick ... sometimes

  • ClaudiaHelpOnVSTO

    can you teach me how to attach the files please help me, I need a solution for this problem

    thanks a lot

    Claudio



  • Cadbury

    ...I'm using SQL Server 2000 developer + sp3

  • recovery a SQL Server db from mdf/Ldf files
Answer this question