Page History

...

1. In the navigation pane, click SQL Safe Agents.
2. Right-click the appropriate SQL Server instance.
3. Click Properties from the context menu.
4. Change the SQL Safe Agent properties to improve the performance of your backup and restore operations,
or
5. enable debug mode for troubleshooting an issue
. For more information about SQL Safe Agent properties, see view agent settings
6. , or configure settings to enable Virtual Database operations.
7. Click OK.
   

Anchor
properties properties

What options can you edit in the SQL Safe Backup Agent properties window?

On the SQL Safe Agent Properties window, you can edit the following settings:

• On the General tab, you can edit by:
  • Status 
    
    • Management Server - the name of the server hosting the SQL Safe Management Service that the Agent is configured to communicate with.
    • Send Status every X seconds - select this option to have the SQL Safe Backup Agent communicate with the SQL Safe Management Service. Also, define communication frequency.
  • Performance
    • Max Load - the maximum number of concurrent operations that the backup agent can perform.
    • Priority - use this option to define the thread priority at which backup agent threads run.
  • Troubleshooting
    • Enable Debug Mode - select this option to enable debug logging on the Agent.
    • The Advanced button provides access to define the following options: More detailed messages, Backup Service Engine, Backup Service I/O, Map Generation, Filter Service Engine, and Filter Service Driver. Additionally, you can set Log Files options and define if you want to roll logs.
• On the SQL Server tab, you can edit by:
  • SQL Server Connectivity
    • Timeout - set the timeout in seconds.
  • Virtual Device Interface (VDI) Defaults
    • Timeout - set the timeout in seconds, which determines how long the Backup Agent will wait for a response from SQL Server before timing out.
    • Buffers - define the number of buffers used for the VDI operation.
    • Transfer Limit - set the maximum size of a transfer block for the VDI operation.
    • Block Size - set the size of a VDI device block. All data transfers are integer multiples of this value.
• On the SQL Virtual Database tab, you can edit by:
  • Default Database File Location - use this option to specify which folder SQL VDB uses to stores data files when creating a virtual database. Click Browse to change the Database File location.
  • Cleanup Unused Files - use this option to remove the temporary files used for a VDB that are left behind after the database is deleted. Click Clean Up to remove these files and free up space.

Why should you enable troubleshooting?

...

There is no disadvantage to leaving SQL Safe in debug mode for an extended period of time. If you experience an issue that occasionally and unexpectedly occurs, or you want to capture data over a long period of time, leave debug mode enabled. This settings setting gives you the advantage of already logging the data when the issue occurs.

...