To reset the database options.

1. In Enterprise Manager, double-click a database.

2. Click the Options tab.

3. Turn off these SQL Server options:

   • Select Into\Bulk Copy

   • Truncate Log on Checkpoint

   Repeat this process for each -related database.