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.
Need more help? Search the IDERA Customer Support Portal