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 :
Click to enlarge


2 . If the target database has been existed , the "Force replace existing ... ..." option should be seleted either.

3 . 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. By selecting "Move ... ..." option and clicking the "Edit Location" button ,you can define new database directories , see following :

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

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



Download ms sql server backup and restore software
Download Now
 
More 5 Start Award ....


No risk 30 days money backup guarantee


Download ms sql server backup and restore software
Download Now
 

Copyright @2005-2009 by DataBK.com, all rights reserved.