Backing Up a Database

WinSQL offers an offline backup utility that can be used in place of your native backup utility. One of the primary advantages of using WinSQL’s backup utility is that it offers the flexibility of backing up one type of database and, if desired, restoring to a different type of database.

Additionally, WinSQL’s backup utility is always available and is not dependent on outside resources, such as an ISP backup service whose resources are shared by many users.

Important note: WinSQL’s backup utility is limited to backing up only certain objects in the database, such as tables, views, stored procedures, and triggers. Other database-specific objects, such as user logins, user defined data types, and sequences are not eligible for back up.

Perform the following steps to back up 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          Accept the default option to back up all objects in the database

          OR

          Click the Let me pick the object I want to back up option. If this option is selected, you must click to select the check box by each object you wish to back up.

4          Accept the default backup file name and location, or click browse to select another location and/or file name.

5          Click Back up.

When the backup has completed, a window similar to the following displays:

6          If you wish to view the backup file, click Yes. Otherwise, click No to close this window.