Discussion Locked

SQL Database

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a SQL database in the form of a set of MDF and LDF files. They were created in a previous installation of SQL 2000 Eval. edition, which became corrupt and had to be uninstalled. I need the data for use in a fresh installation of SQL 7.0, but I don't know how to import the data. Does anyone know how I can get SQL 7 to recognize the MDF as a data source?

4 replies

by maxwell edison

Copy the MDF files to the necessary folder ? usually C:\MsSQL7\Data. Attach the database using the Sp_Attach_Db stored procedure from the Master database in Access. Then the stored procedure asks you some questions, and you respond accordingly.

by maxwell edison

.
.
Correction:

Copy the MDF - AND LDF - files to the necessary folder ....

Good luck. I hope this helps,

Max

This discussion is closed to new replies.