Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    2

    Unanswered: Restoring datbase on different machine

    Hi All,

    I am using SQL serve 2000. My client has sent me one database. I want to restore here. How do I restore the database which has been sent to me.

    Vini

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    hi vini,
    what do u mean by the client has sent u a database? I mean is it a database backup or the database file(mdf)??
    If it is a backup of the database then you can create a empty database and restore the database backup on this new database.
    If it is a database file (mdf) then attach the database to the database server.
    regards,
    harsh.

  3. #3
    Join Date
    Sep 2003
    Location
    KY
    Posts
    146

    Hi

    To restore a dump from other Server , you don't have to create an empty database !! Use RESTORE COMMAND WITH MOVE option (See BOL) or USe Enterprise manager , Right click any existing database : Click Restore : Change the name to New Db , In Options tab , amke sure the Physical File Path is Correct matching to the Server you are restoring , Click Force Restore and Hit OK .

    For MDF Files If you do not have Log File with it , sp_Attach_singly_file might work but you are likely to loose the transactions which are uncommited and sitting on MDF file ..

Posting Permissions

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