Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2002
    Posts
    7

    Unanswered: how to restore the sqlserver2000's mdb files to another sqlserver

    Hi there,
    My sqlserver 2000 was down(means failed to reload ) I just copied all the mdb files and log files from that server. now i wants to reload my databases from the mdb files. is it possible?. If so pls inform me how to do that.

    Its very urgent. Pls help me:
    confused:

  2. #2
    Join Date
    Dec 2001
    Location
    Toronto, Canada
    Posts
    335
    If you have all of the MDF and LDF files look into using SP_ATTACH_DB. After that you'll need to recreate the logins in MASTER from those in your databases.
    MCDBA

Posting Permissions

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