import data to sql2000

Last Post 14 Jun 2004 10:42 PM by satya. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

14 Jun 2004 06:44 PM
I have two files with the extension .mdf and .ldf from sql 7.0, how can I import it to the new installed sql 2000 server and using the data.
Becasue the old version sql.7 server already dead and can't boot up again.


New Member
New Member

14 Jun 2004 10:42 PM
You can use SP_ATTACH_DB to attach those .MDF & .LDF files and ensure they were detached properly using SP_DETACH_DB previously.

If not you can restore from a backup file for ver.7 to SQL 2000 using RESTORE statement.

Acceptable Use Policy