Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004
    Posts
    3

    Unanswered: Import mdf file to server

    Hi.

    I have my *.mdf and *.ldf file and need to import it to my new sqlserver 2000.

    Can anybody tell me how to do it

    BEST REGARDS

    Badleif

  2. #2
    Join Date
    Feb 2003
    Location
    Milano, Italy
    Posts
    80
    Easy, you only need to attach the database. You can use the sp_attach_db system prodedure or go with the enterprise manager: right click on

    your_server_name/databases

    and the select "Attach Database"

    and it's finished.
    Davide Mauri
    http://www.davidemauri.it

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •