Results 1 to 5 of 5

Thread: MS SQL restore

  1. #1
    Join Date
    Nov 2004
    Posts
    10

    Unanswered: MS SQL restore

    I have a MS SQL database backup from a client and would like to use this to create the database on my local machine.

    I have been advised to do this by using restore database in enterprise manager.

    I am lost though as I really dont know much about MS SQL - sorry people but can anyone tell me how to do this?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Sure.

    -PatP

  3. #3
    Join Date
    Nov 2004
    Posts
    10

    Thanks - i think i know the problem

    I think they had the database on their D:/ drive and I only have a C: drive

    That is whats causing the problem I think.

    Any suggestions on how to get round this?

    Thanks

    Paul

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    When restoring in EM, click on Options tab and change the path for every device there.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  5. #5
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    and buy a copy of this book...
    Inside SQL Server 2000 By Kalen Delaney

Posting Permissions

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