Creating a Backup for SQL Server

To create a backup for SQL Server:

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

2. On the Database/Object Transfer form, select a destination server and database on which to create backup copies of the tables.

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

3. Keep all default settings and then click the Start Transfer button.

   The Database/Object Transfer tool moves the objects.

4. Perform either of these tasks 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.