i have a question on mdf / ldf

Do you mean you have existing files you want to load to sql server?

Just copy them to the server and execute this from query analyzer:

sp_attach_db 'whatyouwanttocallit','path:\auto.mdb','path:\auto.ldf'

Brett

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ae-az_52oy.asp

Hi khan2000,


assuming the files are sql server files which where properly detached for there existing server
and that that server is / was at the same patch / version level as the server you are
trying to install them on...

Cheers!

and please maintain your old questions....
9 open questions:
12/06/03 https://www.experts-exchange.com/questions/20817985/i-have-a-question-on-mdf-ldf.html "i have a question on mdf /  ldf"
11/21/03 https://www.experts-exchange.com/questions/20805367/free-news-server-nntp.html "free news server nntp"
11/21/03 https://www.experts-exchange.com/questions/20805336/difference-between-sql-6-5-vs-7-0-vs-2000.html "difference between sql 6.5 vs 7.0 vs 200..."
11/13/03 https://www.experts-exchange.com/questions/20797256/does-anybody-have-mcdba-cbt.html "does anybody have mcdba cbt?"
11/11/03 https://www.experts-exchange.com/questions/20794833/I-NEED-very-good-web-sites-for.html "I NEED very good web sites for..."
10/28/03 https://www.experts-exchange.com/questions/20780872/pop-account.html "pop account"
10/07/03 https://www.experts-exchange.com/questions/20759897/display-a-status-window.html "display a status window"
09/22/03 https://www.experts-exchange.com/questions/20745377/i-need-logic-pls.html "i need logic pls."
09/12/03 https://www.experts-exchange.com/questions/20737487/how-do-i-write-code-in-aspx.html "how do i write code in aspx"

Hopefully 'mdb' was a typo. MDB is an Access file (unless of course it was renamed from MDF)

yes, it was a typo--I'm aware of the difference between and MDB and MDF.....

My comment was addressed to the original question.... I figured you would know!  :)