SQL Backup Master will then execute the following steps:ġ.The database backup file will be downloaded from its current backup destination. When you are ready to recover the database backup, click the Begin Recovery button. When restoring differential or transaction log backups, the file listing will be read-only. IMPORTANT : SQL Server supports the specification of file locations only for full backups. Note that any restore file location that you choose must be accessible to SQL Server, so it may be necessary to adjust file system permissions accordingly. Once shown, restore paths can be edited by clicking the associated browse button or double-clicking a restore path. SQL Backup Master allows you to modify backup file locations during a restore operation.ĭefault restore file locations will be listed after a backup file has been successfully downloaded. For more information regarding the sequencing of restore operations, please consult your SQL Server product literature. You should elect to leave the database in a non-operational state only if you plan on executing additional recovery steps (such as recovering subsequent differential or transaction log backups) immediately thereafter. running, full recovered) state or it can be left in a non-operational state. To restore the backup to a different database, either select a new database name (via the drop-down arrow) or type in a new one.ĭuring the database recovery process, SQL Backup Master can either leave the database in a 'ready to use' (e.g. To restore the database backup file to a different SQL Server instance than the one that created it, click the hyper-linked SQL Server instance name and choose a SQL Server instance. Target database - The name of the target database to which the backup file will be recovered.SQL Server instance - The instance of SQL Server to which the database backup will be recovered.Backup type - The type of database backup being recovered.Database name - The name of the source database that will be recovered.The backup summary panel indicates the following: IMPORTANT : When recovering a database backup from within SQL Backup Master, you should run SQL Backup Master from a Windows account that is a member of the System Administrator role in SQL Server. The Recover Database window will be shown. You recover a database within SQL Backup Master by running the Database Backup Recovery Explorer and then clicking the Restore from backup action link associated with a specific database backup file.

Download sql backup master