Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The SQL Safe Agents

...

 tab allows you view all servers that host instances in your environment.

...

For each server you can see the following information:

  • Status - it displays the status of the SQL Safe Backup Agent which could be:

...

    • Ok (green) - the SQL Safe

...

    • Backup Agent

...

    • is available and configured correctly.
    • Warning (yellow) - SQL Safe connected to the SQL Safe Backup Agent but the Backup Agent is not the most current version or is not configured for the same management service.

...

    • Error (orange) - SQL Safe cannot connect to the Backup Agent

...

    • on the server.
  • Computer

...

  • name - the name of the computer where the SQL Safe Backup Agent is running.

...

  • Version - the version of the SQL Safe Backup Agent.
  • Management

...

  • Server - the name of the management server that the SQL Safe Backup Agent is configured for.
  • Max Load 

...

  • - the maximum number of concurrent operations that can be executed by the SQL Safe Backup Agent.

...

  • Priority - displays the Windows thread priority at which the Backup Agent threads run.
  • Send

...

  • Status - displays the frequency with which the agent is configured to communicate with the Management Server.
  • SQL

...

  • Timeout - displays the SQL DMO timeout value, which determines how long the Backup Agent will wait for a response from SQL Server before timing out.
  • VDI Trans

...

  •  Limit,

...

  •  bytes - displays the maximum size of a transfer block for the VDI operation.
  • VDI Buffers,

...

  •  bytes - displays the number of buffers used for the VDI operation.
  • VDI Block Size,

...

  •  bytes - displays the size of a VDI device block. All data transfers are integer multiples of this value.
  • VDI Timeout,

...

  •  seconds - displays the timeout for configuring the VDI.

...

  • Actions - allows to access the options for editing server properties, installing/upgrading SQL Safe Backup Agent, and Enabling/Disabling Instant Restore. 
Tip

Keep in mind:

  • You can sort the information available on this tab by clicking the column header by which you want to order your instances.
  • You can set the number of items you want to view per page by going to the lower section of the list grid, type a number in the box, and the page will be updated according to your requirements.

How can you filter your information?

You can filter the information of the SQL Safe Agents tab to access your data quickly.

Filter your information by

...

:

  • Status - it displays the status of the SQL Safe Backup Agent which could be:
    • Image Added Ok - the SQL Safe Backup Agent is available and configured correctly.
    • Image Added Warning - SQL Safe connected to the SQL Safe Backup Agent but the Backup Agent is not the most current version or is not configured for the same management service.
    • Image Added Error - SQL Safe cannot connect to the Backup Agent on the server.
  • Computer Name - type the computer name.
  • Version - type the Backup Agent version.
  • Management Server - type the Management Server configured for the Backup Agent.
  • Max Load - set a range using the From and To options. 
  • Priority - type the priority.
  • Send Status - select from the On and Off options.
  • VDI Trans Limit, bytes - set a range using the From and To options. 
  • VDI Buffers, bytes - set a range using the From and To options. 
  • VDI Blocksize, bytes - set a range using the From and To options. 
  • VDI Timeout, seconds - set a range using the From and To options. 
Tip

When using filters take into account:

  • You can save your filtering options by selecting your filters, typing a name in

...

  • the By Custom Filter field, and clicking Add Filter. To retrieve your saved filters, click

...

  • the drop-down option in the By Custom Filter section and select your filter name.

...

When using filters take into account:

  • If you want to select filters first and apply the changes later,

...

  • deselect the Apply filter as it

...

  • changes option.
  • To remove filters, use the specific Remove Filter option in each filter. For example, if you want to remove your

...

  • Status filters, click Remove Status Filter under the same filter section.
  • Under 

...

  • APPLIED FILTERS on the top section

...

  • or your SQL Safe

...

  • Agents tab, you can see the filters you have selected. Click the X icon next to the ones you want to remove.
  • Use the option Clear on the top section of the

...

  •  Filtering section to remove all filters.

...

  •  

What other options are available on the  SQL Safe Agents tab?

You can also find the following options in the upper section of the SQL Safe Agents tab:

...

  • Export - use this option to export the information displayed on

...

  • the SQL Safe Agents tab. You can select your preferred format: PDF, XLS, or XLM. 
  • Refresh Image Added - use this option to get the latest status of your SQL Safe Agents.

What options

...

can you edit in the properties window?

When you select one SQL Safe Backup Agent, you can access its properties. Administrators and users are able to change the following properties:

Click the Image Added gear icon at the end of the row and select properties. On the 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.
    Management Server - you can change the name with which SQL Safe displays your server
      • Send Status every X
    seconds
      • seconds - select this option to have
    your server status sent after the number of seconds you specify. 
  • Max Load - define the number of jobs that SQL Safe will use as the maximum load for the server. 
      • the SQL Safe Backup Agent communicate with the SQL Safe Management Service. Also, define the frequency of the communicate.
    • Performance
      • Max Load the maximum number of concurrent operations that the backup agent can perform.
      • Priority 
    Priority
      • - use this option to define the thread priority at which backup agent threads run.
    • Troubleshooting
      • Enable Debug Mode -
    Select this option and go to Advanced Settings to
      •  select this option to enable debug logging on the Agent.
      • The Advanced button provides access to define the following options:
     More
      • More detailed messages,
     Backup
      • Backup Service Engine,
     Backup
      • Backup Service I/O,
     Map
      • Map Generation,
     Filter
      • Filter Service Engine,
    and Filter
      • and Filter Service Driver. Additionally, you can
    set
      • set Log Files
    options
      •  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,
    how often, and at what size. 
SQL Safe is a high-performance backup and recovery solution for your SQL Servers. Learn more > >

...

      •  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.

When you finish configuring your Agent Properties, click Save or Cancel the configuration.



Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse

...