How to import .MDF and LDF files into local SQL Server 2000

[65]

Hi All,

Anyone please direct me how to import MDF and LDF files, which are stored on two different floppy disks into local SQL Server 2000. As a new user of SQL Server 2000, I also need your help to point me where I am able to get good online sources to educate myself. Your help is greatly appreciated.

Thanks in advance
Lenka.

 

[tlbroadbent]

Use SQL Books Online as the first reference. If you don't what SQL BOL are or where to find them check faq183-689. There are also many good resources listed in the SQL Server Resources topic in the FAQ area of this forum.

Copy the MDF and LDF files to a drive on the server or PC, preferably to the SQL Server data area. Then attach the files using SQL Server Enterprise Manager or SQL Server Query Analyzer. See the following SQL BOL links.

How to attach and detach a database (Enterprise Manager)

http://msdn.microsoft.com/library/en-us/howtosql/ht_7_design_4wq1.asp

sp_attach_db

http://msdn.microsoft.com/library/en-us/tsqlref/ts_sp_ae-az_52oy.asp

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[65]

Hi Terry,
Thanks for your very helpful information. I do appreciate it very much.

Lenka