Hi Edmin!

In the Enterprise manager, Right Click on "Databases" under the server inm
which u want to install, select "Select all tasks" then "attach database".
and give the MDF and LDF path there.

Regards,

Prashant Thakwani
[Email address protected]
Database Administrator



-----Original Message-----
From: Edwin Uy
[mailto:mssqldba-ezmlmshield-x31594244.[Email address protected]
Sent: Monday, May 31, 2004 4:38 PM
To: LazyDBA.com Discussion
Subject: Restoring database with existing MDF and LDF


Hi all .



Just a newbie in SQL, I have the MDF and LDF file, how do I restore or
re-create this database?



Cheers,

EDWIN ONG UY
\\|//
(o o)
^"^"^"^"^"^oOOo"^(_)^"oOOo^"^"^"^"^"^"^"^"^"^"^

"Choose a job you love, and you will never have to work a day in your
life." --Confucius
"How do I work? I grope." -- Albert Einstein
"Experience is the best teacher, enrolling in the class is the biggest
problem." -- Anonymous





---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]





MS Sql Server LazyDBA home page