Restoring a Backup File for SQL Server

To restore a backup file for SQL Server:

1. Verify that the Choose Into/Bulk Copy option on the Options form is turned on for the database into which you will transfer objects.

   Double-click the database in the tree structure to access the Options form.

2. From SQL Enterprise Manager, select Database/Object Transfer from the Tools menu.

3. On the Database/Object Transfer form, select a destination server and database from which to transfer backup copies of the tables.

   Note: The source server and the destination server can be the same, but the database must be different.

4. Deselect the Transfer All Objects option, but keep all of the other default settings.

5. Click the Choose Objects button, select the objects that you want to transfer, and then click OK to return to the Database/Object Transfer form.

6. Click the Start Transfer button.

   The Database/Object Transfer tool moves the objects.

7. Perform either of these to verify whether the backup was successful:

   • When the process completes the transfer, click the View Logs button to review the transfer process.

   • Run a SELECT statement to verify that the backup tables transferred to the new database with data.