Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2003
    Location
    Malaysia
    Posts
    1

    Unanswered: restore *.bak file to DB

    hi there.......
    i got stuck when i tried to restore backup file (*.bak) into my existing db.

    for u'r info i just make a backup from my DBase1 named BackupDB1.bak then,
    i would like to restore this BackupDB1.bak into existing DBase2 db.
    then i got an error...

    please give me some ideas or solution...
    Tq..

  2. #2
    Join Date
    Feb 2003
    Location
    Milano, Italy
    Posts
    80
    hi

    you have to use the REPLACE option with the RESTORE command.

    Look for help in the Book on line: RESTORE, RESTORE (described)
    Davide Mauri
    http://www.davidemauri.it

  3. #3
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    What is the exact error you are getting

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    True you should specify the error message to assess the issue.

    Also are you trying to restore SQL database to a dbase2 database?
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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