Monday, March 26, 2012

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.

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

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

thanks a lot

Claudio

|||

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

|||...I'm using SQL Server 2000 developer + sp3|||Open Books Online. Do a search for Attach. It will have instructions and sample code.

No comments:

Post a Comment