You can also perform defragmentation using the command line utility sqldefragc
included with the SQL Defrag Manager installation.
Note: run the command line consola as Administrator
sqldefragc [[[–rebuild [online]] | –reorg] –instance <instance name> –database <database name> | –policy <policy name>]
You can use sqldefragc
in two different ways:
Define the defragmentation as follows: specify "rebuild" or "reorg" where "online" is optional for "rebuild"; specify the "instance name"; and specify the "database name".
Define the defragmentation based on an existing policy by specifying the "policy name".