Post reply

How to Import the .mdf file

  • September 27, 2001 at 11:44 pm

    #57817

    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

    #418563

    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

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

  • September 28, 2001 at 2:45 am

    #418566

    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