Restoring a Database

Perform the following steps restore a database:

1          Connect to the database you wish to back up. For more information, see “Establishing a Database Connection.”

2          From the Tools menu, point to Offline Backup, and then click Backup. A window similar to the following displays:

3          Click Browse to navigate to the location where your backup file is located, click to select the file, and then click Open.

Note: If the source database type is different from the target database, WinSQL displays a warning message that only data will be restored. In such cases, you cannot restore views, stored procedures or triggers.

4          Click Next. A window similar to the following displays:

5          Click Restore all objects in the database

          OR

Click the Let me pick the object I want to restore option. If this option is selected, you must click to select the check box by each object you wish to restore. Double click a table name to view the CREATE TABLE statement

6          Once all options have been selected, click Next. A window similar to the following displays:

7          Verify the order in which the objects will be restored. If necessary, click the Up and Down arrows to rearrange the objects.

Note: The restoration order is important in cases where tables are related to each other. For example, assume that the “Orders” table contains a field that refers to the primary key in the “Customer” table. In this case, you must restore the parent table prior to restoring the children tables.

8          Click Next. A window similar to the following displays:

9          Click Drop existing tables in the target database to allow the restore process to create new tables in your database

OR

Do not select this option to allow the restore to append data from the backup file to the existing database tables.

10          Click Abort operations if an error occurs to prevent the restore from continuing to run if an error is encountered during the restore.

11          Click Restore.

When the restore has completed, the following window displays: