Restoring backups - SQL Backup

SQL Backup provides a wizard to guide you through the process of Restoring Backups. To start the Restore wizard, click Restore, or in the Activity History, right click the backup and click Restore.

The Restore wizard comprises the following steps:

Restoring multiple backups

You can restore multiple full, differential, and transaction log backups that belong to the same backup set using the Restore wizard. For example, you can restore a full and differential backup for the same database at the same time. Details of how to do this are given in step 1 (select backups).

You can restore the latest set of backups for a particular database (the latest full backup, a subsequent differential backup and all available transaction log backups) using the Schedule Restore Jobs wizard or the command line or extended stored procedure. See Scheduling restore jobs or The RESTORE command for more information.

You can restore multiple transaction log backups for a particular database using the command line or extended stored procedure. See The RESTORE command for more information.

Restoring the master database

To restore the master database, you must use the SQL Backup command line to ensure that the SQL Server is started in single user mode. See Using the command line for more information. It is not possible to restore the master database with the Restore wizard.

1. Stop the SQL Server service.
2. Open a command prompt window, and navigate to the SQL Server instance's Binn folder.
3. Start SQL Server in single user mode using sqlservr.exe ‑c ‑m for an unnamed instance, or sqlservr.exe ‑c ‑m ‑s {instancename} for a named instance.
4. Use the SQL Backup command line interface to restore the master database.

   For example, at the command prompt, type:

   SQLBackupC.exe -SQL "RESTORE DATABASE master FROM DISK = 'C:\Backups\master 20070101.sqb'"

   For a named instance, use the -I parameter to specify the instance name, for example:

   SQLBackupC.exe -SQL "RESTORE DATABASE master FROM DISK = 'G:\Backups\master 20070101.sqb'" -I Instance2

   SQL Backup restores the master database, and SQL Server automatically stops the SQL Server service when the restore operation is complete.

5. You can now start the SQL Server in normal mode.

Restoring individual database objects

If you want to restore individual objects from a SQL Backup .sqb file, use SQL Object Level Recovery Pro. This application, included with SQL Backup, can recover individual objects to a database, with potentially large savings in time and disk space. For more information, see About object level recovery.

Next: select backups