Tuesday, February 21, 2012

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..hi

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

Look for help in the Book on line: RESTORE, RESTORE (described)|||What is the exact error you are getting|||True you should specify the error message to assess the issue.

Also are you trying to restore SQL database to a dbase2 database?

No comments:

Post a Comment