Post reply

How to attach .mdf file?

  • April 21, 2005 at 9:38 am

    #88727

    Hi,

         We have a new SQL Server 2000 database, and I received the .mdf file, what is the correct step to attach this .mdf into the new database?

    Thanks.

  • April 21, 2005 at 9:56 am

    #554124

    Enterprise manager=> Right-click Databases, and select All Tasks/Attach Database.

    Good luck

  • April 21, 2005 at 10:22 am

    #554138

    sp_attach_single_file_db

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • April 21, 2005 at 10:37 am

    #554147

    Thanks. It's really helpful.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply