HP Serveur lame HP ProLiant BL465c Gen8 - Manual (Page 381)

Figure 107 System configuration for restoring data to an SQL Server instance different from the backup
source
For example, if only the user database backed up from the SQL Server instance instA of database
server 1 is restored and recovered to SQL Server instance instB of database server 2, the user
database from database server 2 becomes available.
System databases such as master, model, and msdb cannot be restored to a different SQL Server
instance.
This example assumes the following conditions:
• The same version of SQL Server is installed on both database server 1 and database server 2.
• The database file path configuration is the same both on database server 1 and database server
2.
• The VDI metafile storage directory is not specified by the drmsqlinit command on both database
server 1 and database server 2.
Operation flow
A flow of operation for restoring data to an SQL Server instance other than the backup source is
shown below.
Preparations for restoration (recovery)
Make sure that SQL Server instance instB has been started on database server 2.
Application Agent CLI User Guide 381