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.

[488 byte] By [ClaudioBello] at [2008-2-23]

«« Windows XP Hotfix KB921883
»» rss reader

# 1

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

bass_player at 2007-8-30 >

top of Msdn Tech,SQL Server,SQL Server Disaster Recovery and Availability...

# 2

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

thanks a lot

Claudio

ClaudioBello at 2007-8-30 >

# 3

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

bass_player at 2007-8-30 >

# 4

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

ClaudioBello at 2007-8-30 >

# 5

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

MichaelHotek at 2007-8-30 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Question about 'recovery a SQL Server db from mdf/Ldf files', No.622306,Posted by ClaudioBello

recovery a SQL Server db from mdf/Ldf files

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Site Classified