HOW TO: On Demand SQL Server Database Restore

If you are using RockSolid to backup your SQL Server databases via the automated management functions, you can request on demand restoration of a given database via the RockSolid interface.

In order to perform database restores on demand the database backup method must be native SQL Server backups to disk.  The backupset being restored must be available on disk to begin the restore.

NOTE: If the required backupset is not available on disk, ensure the files are first restored to disk by your upstream backup process.

Restoring Databases On Demand

To restore a SQL Server database perform the following steps:

  • Navigate to the instance where the backup was initiated via the Manage Instances screen.
  • Click on the Databases tab and click on the relevant database for which you wish to restore from backup.
  • Click on the "Recent Backups" sub tab on the database Overview tab.
  • The recent backups tabs shows recent database backups broken down into groups by full, differential and log backups.
  • Database backups which are currently available on disk, and have their relevant prerequisite backups also available on disk with have the restore icon indicating that these are available for restoration.

To restore a backup click on the restoration icon for the required backup file (either a full, diff or log backup file).

This will show the restore backup form.  On this form information as the source instance, database, backup time and type will be displayed.

  • By default RockSolid we suggest the backup be restored to a new database being named in the format of <ORIGINAL DB NAME>_AsAt_>Backup Date/Time>.  You can either select this database name or edit the database name text box to an alternate database name.  If you wish to overwrite an existing database enter the name of the existing database here.
  • RockSolid will map the restored database files to relevant directory structure the restored instance.  If you wish to change the location where the files are being restored to edit these here.
  • When you are ready to proceed with the restore click the Restore Database button.
  • If you are overwriting an existing database you will be prompted to enter the WORD "OVERWRITE" into the prompted text box.  This step is to confirm that you are aware that you will be overwriting an existing database, which may result in data loss, and you are aware there is no undo process for this.
  • Once you have entered please click the Restore Database button again.

At this point RockSolid will raise a new service request of task type "Restore Database" to restore the required backup.  This will progress via the normal service request processes and may require additional approval or automated approval before the restore initiates.

Have more questions? Submit a request


Please sign in to leave a comment.