import data to sql2000

Last Post 14 Jun 2004 11:42 PM by satya. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
walkerstephen
New Member
New Member

--
14 Jun 2004 07: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.

regards

stephen
satya
New Member
New Member

--
14 Jun 2004 11: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.
You are not authorized to post a reply.

Acceptable Use Policy