Restoring an SQL Server Full Backup

Owned by Verba Support (Unlicensed)
Nov 04, 2013
2 min read

This section explains how to restore a full Verba database backup.

 

Step 1 After you connect to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.

Step 2 Expand Databases. Select verba database.

Step 3 Right-click the database, point to Tasks, and then click Restore.

Step 4 Click Database, which opens the Restore Database dialog box.

Step 5 On the General page, the name of the restoring database appears in the To database list box.

Step 6 In the To a point in time text box, either retain the default (Most recent possible) or select a specific date and time by clicking the browse button, which opens the Point in Time Restore dialog box.

Step 7 To specify the source and location of the backup sets to restore, click one of the following options: 

  • From database

    Enter a database name in the list box.

  • From device

    Click the browse button, which opens the Specify Backup dialog box. In the Backup media list box, select one of the listed device types. To select one or more devices for the Backup location list box, click Add.

    After you add the devices you want to the Backup location list box, click OK to return to the General page.

Step 8 In the Select the backup sets to restore grid, select the backups to restore. This grid displays the backups available for the specified location. By default, a recovery plan is suggested. To override the suggested recovery plan, you can change the selections in the grid. Any backups that depend on a deselected backup are deselected automatically.

Step 9 To view or select the advanced options, click Options in the Select a page pane.

Step 10 In the Restore options panel, you can choose the following option: Overwrite the existing database

For further information about restoring a full database backup using SQL Server Management Studio or SQL Server Management Studio Express, refer to http://msdn.microsoft.com/en-us/library/ms177429.aspx.