Page History
...
For each database you are restoring, you have several ways to select the restored database name and path. You can:
- Select the target database from the drop-down list of existing databases
- Enter a new database name
- Enter a new database path
- Select restore options for these files
- Edit the filename of the restoring file
When you select a database name from the drop-down list , or edit the field, the Restore As Filename is automatically updated to reflect the new name, but you can edit this field by directly typing on the grid. You can also change the database path by simply editing the filename in the grid.
...
| Action | Steps | |
|---|---|---|
| Create a new database to restore. | Type a new database in the Restore As text box. | |
| Change the path of Specify the target database owner. | Type the DB Owner Enter a new path in the Change path field. | |
| Ensure the selected backup files are restored, even if that means overwriting an existing database. | Select the Force Restore option (replace). | |
| Restore the SQL logins associated with the selected databases | Select the Restore database logins option. This option is available when you are restoring a full backup that contains the database login information. | |
| Restore | databases that usesdatabases that use the Microsoft SQL Server Change Data Capture (CDC) feature. | Select the Keep CDC option. |
| Ignore any errors from the generated checksum. If checksum errors are encountered, SQL Safe should continue to restore the backup file. | Select the Ignore checksum errors optionChecksum Errors option. | |
| Retain the settings used when the selected databases were replicated. | Select the Preserve replication settings option. | Include a temporary download location to restore very large files from cloud storage. Instead of restoring on the fly, this option allows you to download the file completely first and then perform a normal restore. This may help if you are running into memory or streaming issues when working with very large files. The file location is relative to the target server where the database will be restored to. | Select the Download File from Cloud option
Prioritize your restore operation. | Select the Prioritize Operation option. | |
Change the path of the target database. | Enter a new path in the Change path field. |
Can you overwrite an existing database?
...