Restore sql data base
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.
Networks
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.
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.
Sort by Trending