Discussion Locked

Restore sql data base

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have only .mdf and .ldf files for sql7.0 data base.how can i get data from those files
pl help me in this regard.

7 replies

by tims

First thing to do is install Microsoft SQL Server 7.0 if you have not done so already. (Microsoft has eval copies available for the cost of shipping). After you successfully installed MSSQ7, create a new database and run the sp_attach_db stored procedure: (excerpt from MSSQL7 Books On-Line)
EXEC sp_attach_db @dbname = N'your_db',
@filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\your_db.mdf',
@filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\your_log.ldf'.

I did leave out a few details, but this should head you in the right direction.

by tims

First thing to do is install Microsoft SQL Server 7.0 if you have not done so already. (Microsoft has eval copies available for the cost of shipping). After you successfully installed MSSQ7, create a new database and run the sp_attach_db stored procedure: (excerpt from MSSQL7 Books On-Line)
EXEC sp_attach_db @dbname = N'your_db',
@filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\your_db.mdf',
@filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\your_log.ldf'.

I did leave out a few details, but this should head you in the right direction.

by tims

First thing to do is install Microsoft SQL Server 7.0 if you have not done so already. (Microsoft has eval copies available for the cost of shipping). After you successfully installed MSSQ7, create a new database and run the sp_attach_db stored procedure: (excerpt from MSSQL7 Books On-Line)
EXEC sp_attach_db @dbname = N'your_db',
@filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\your_db.mdf',
@filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\your_log.ldf'.

I did leave out a few details, but this should head you in the right direction.

This discussion is closed to new replies.