The Server Group Tags view lets you view a list of tags that are available in IDERA SQL Secure. Click a tag, and SQL Secure displays the list of SQL Servers within that tag at the bottom of the view. Use tags to group or organize instances for better management when taking snapshots. You can:

  • snapshot all the servers you have registered
  • snapshot a particular tagged group of servers
  • snapshot a specific set of multiple tagged servers

For more information about snapshots, see Use snapshots to collect audit data.

Managing tags

Users can create, edit, and delete tags using the Server Group Tags view available from the Manage SQL Secure view.

To create a server group tag:

  • Click Create Server Group Tag.

To edit an existing tag:

  1. Right-click the tag you want to edit, and then select .
  2. Make the appropriate change(s), and then click .

To delete an existing tag:

  • Right-click the tag you want to delete, and then select Delete Tag. SQL Secure removes the tag from the list and no longer offers the tag as an option when registering a server.

Adding servers to a tag

You can add servers to a server group tag using the following process or a similar process that occurs in the Register a SQL Server wizard.

To add a SQL Server to a tag:

  1. In the Manage SQL Secure view, click the Server Group Tags option.
  2. Right-click the tag to which you want to add a SQL Server, and then select Add a server.
  3. Select the SQL Server(s) you want to add to the tag.

Creating a snapshot

Selecting SQL Servers to include in a snapshot is much faster when the servers all are tagged with the same server group tag. Use the following steps to take a snapshot from a tag already populated with the appropriate SQL Servers.

To take a snapshot of the servers in a tag:

  1. In the Manage SQL Secure view, click the Server Group Tags option.
  2. Take the snapshot using one of the following processes:
    • Select the tag you want to snapshot, and then select Take Snapshot Now from the Snapshots menu.
      OR
    • Right-click the tag you want to snapshot, and then select Take Snapshot Now.
      SQL Secure takes a snapshot of the servers in the selected server group tag.

 

SQL Secure tells you who has access to what on your SQL Server databases. Learn more > >
IDERA WebsiteProductsPurchaseSupportCommunityAbout UsResources Legal
  • No labels