Within a single recovery task, you can recover multiple databases. The databases are automatically mapped to their original instances. You can select a target instance for each database, if necessary.
System databases are recovered in the same way as user databases. When recovering the master database, the software automatically restarts the destination instance in the single-user mode. After the recovery completes, the software restarts the instance and recovers other databases (if any). Other things to consider when recovering a system database:
To recover databases to instances
On the Recover data page:
If your current account does not have enough privileges to access the target SQL Server instance, you will be asked to provide the credentials.
This is the default setting that fits most situations. The database in the target instance will be overwritten with the database from the backup.
This setting lets you retain the existing database. A recovered database will have the following name: <original database name>-Recovered. If a database with this name already exists, the recovered database will be named as follows: <original database name>-Recovered (<sequence number>).
Examples: MyDatabase-Recovered, MyDatabase-Recovered (2).
After the recovery completes, the database will be ready for use. Users will have full access to it. The software will roll back all uncommitted transactions of the recovered database that are stored in the transaction logs. You will not be able to recover additional transaction logs from the native Microsoft SQL backups.
After the recovery completes, the database will be non-operational. Users will have no access to it. The software will keep all uncommitted transactions of the recovered database. You will be able to recover additional transaction logs from the native Microsoft SQL backups and thus reach the necessary recovery point.
After the recovery completes, users will have read-only access to the database. The software will undo any uncommitted transactions. However, it will save the undo actions in a temporary standby file so that the recovery effects can be reverted.
This value is primarily used to detect the point in time when a SQL Server error occurred.