June 26, 2008 at 10:16 am
How to restore a database to a different instance on the same server?
Thanks for the help.
June 26, 2008 at 10:24 am
use "move" option in restore command to do this.
[font="Verdana"]--www.sqlvillage.com[/size][/font]
June 28, 2008 at 11:05 pm
*) Login to the source instance, take backup of the db
*) Login to the destination instance, restore the db from backup, you need to use WITH MOVE parameter to place the physical files to correct location.
*) Once restored you need to fix orphan ID's, check the link http://www.fileformat.info/tip/microsoft/sql_orphan_user.htm to do the same.
Regards..Vidhya Sagar
SQL-Articles
June 29, 2008 at 10:23 am
Vidhya has a good procedure. You can also detach the files, copy them with new names, and attach them to the new instance.
Note this doesn't move logins, so you might have orphaned users in the database. Use sp_change_users_login to sync things up or sp_help_revlogin (on this site) for SQL 2000 scripting of logins.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply