Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 How To Get My old MDF Files To SQL 7 Database

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-11-08 : 07:22:42
Rudi writes "I had the Old MDF Files on my server, because the trouble of my server I had to reinstall my new microsoft windows and destroy my sql 7 status, I forgot to Export my old MDF Files to Ms.Access for backup data. So My important data base is in it. How to get my old MDF Files to the SQL Database.
It Is very urgent and important Please........."

nr
SQLTeam MVY

12543 Posts

Posted - 2004-11-08 : 07:43:28
See sp_attach_db and sP_attach_single_file_db
Good luck.

Also have a look at the backup command. You should never rely on .mdf files and copying data to access will only give you the data (if you are lucky).

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -