Microsoft® SQL Server 2012 Unleashed

Restoring to a Different Database

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