You can restore a database backup to a different database. The database you’re restoring to can be on the same server or a different server, and the database can be restored to a different name, if needed. These types of restores are common in development environments where a production backup is recovered on a development server or multiple copies of the same development database are restored to different database names for use by different groups.
Listing 11.7 shows the T-SQL
RESTORE command you can use to create a new database named
AdventureWorks2012_COPY from the backup of the
AdventureWorks2012 database. Take note of the
MOVE options that specify where the database files for the new