View Source

You can install and deploy SQL Defrag Manager to meet your unique defragmentation and SQL Server environment needs.

Typical environment

A typical SQL Defrag Manager implementation scenario includes the following installations:

Management Console on your workstation
Repository and Management Service on a SQL Server instance

Non-trusted environment

You can install and configure SQL Defrag Manager to defragment SQL Server databases running in non-trusted domains or workgroups.

This configuration includes the following installations:

Management Console on your workstation in a trusted or non-trusted domain.
Repository and Management Service on a SQL Server instance in a trusted or non-trusted domain.

When deploying SQL Defrag Manager to a non-trusted domain, specify an account with sysadmin fixed role rights for the Management Service account and ensure that SQL Authentication is enabled on each SQL Server instance where a SQL Defrag Manager component is installed.

Typical environment

Non-trusted environment

| | | | | | |