Hello !
I have to migrate SQL Server 2000 databse from one web hosting company to another. I have been given only databsae.mdf and database.ldf files.No only I have to migrate structure of the tables but also data contains in those tables.
Thanks in advance.

Well, the <database>.mdf file is the database and all it contains. The .ldf is the log file.

If the data was properly detached from the source server, then all you need to do is place it within reach of the target server and re-attach it. YOu don't need the log file, as a new one will be re-created.

The easiest way is to use Enterprise Manager, click on the server, then right click 'Databases', 'All Tasks', then 'Attach Database...', then point to the mdf file.

You can also use the 'sp_attach_single_file_db' system stored procedure to attach from Query Analyzer.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Your hosting copany should be able to attach the file for you the first time around in case you can not get to it via eterprise manager. At times they also provide an asp front end that will do this for you.



Sal