Versions Compared

Key

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

You can also perform a manual defragmentation using the command line utility sqldefragc included . This utility is included with the SQL Defrag Manager installation. 

Note: You need to run the command line consola console as an Administrator.

Panel
borderStyledashed

sqldefragc [[[–rebuild [online]] | –reorg] –instance <instance name> –database <database name> | –policy <policy name>]


You can There are two ways to use sqldefragc in two different ways:Define the defragmentation as follows: specify "rebuild" or "reorg" where "online"

  1. Specify rebuild or reorg where online is optional for

...

  1. rebuild

...

  1. , specify the

...

  1. instance name

...

  1. , and specify the

...

  1. database name

...

  1. .

...


  1. sqldefragc [[–rebuild [online]] | –reorg] –instance <instance name> –database <database name>
     
  2. Define the defragmentation based on an existing policy by specifying the

...

  1. policy name

...

  1. .

    sqldefragc –policy <policy name>

 

 

Need more help? Search the IDERA Customer Support Portal