You are here

How to restore database with a new database name?

To restore database with new database name , please configure a restore job with following settings:

(Suppose the original name is db1 and the target database name is dbx)

1 . Select the restoration target Backup Agent and Instance ,then just enter new database name in "Restore As" field .(we enter the "dbx"), see following :

2 . An very important thing is that : If original database and the target database are on the same server , you must change the restoration database files directories , or the restoration job will try to overwrite the original database files , that cause restoration job fails. just double clicks on the target file list , you can define new database directories.

3 . In most case , Backup Agent can create target directories if they dosen't exist.

4 . Do other required configuration ,then save and run the restoration job.

Category: 
Download sql server ,mysql backup  restore software