September 27, 2001 at 11:44 pm
Hello everyone how to import the .mdf file into database.
Actually i uninstalled the sql server with out taking backup, now i installed it again, i want the old database files to be back.
with regards
kittu
September 28, 2001 at 2:31 am
So you still have the mdf? In SQL2K, just right click on databases in Enterprise Manager, selet attach, then browse and select the file. In SQL7 you'll need to use sp_attach or sp_single_file_attach - see BOL for syntax.
Andy
September 28, 2001 at 2:45 am
Thank you for kind of reply my dear friend
yes i still have the .mdf file and .ldf file, what i did is just created the database file in the current existing then copied those old mdf and ldf files, i got the tables back in hand.
Thank u freind
with regards
Kittu
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply