How to run ARCserve Database Maintenance from command line
Applies to : ARCserve 15.x, ARCserve 16.x
Running periodic maintenance on ARCserve Database allows us to tune and maintain the database in an efficient state and in manageable size.
We can as well run ARCserve Database Maintenance tasks via Command line using ca_dbmgr command line utility.
General Syntax of the command,
Updates the statistics on all the tables and indexes in your database.
SQL Server collects statistics about the distribution of data in tables and indexes and uses these statistics to determine which indexes to use during a query process. If the statistics are outdated, SQL Server might not be able to properly evaluate which indexes to use when executing a query and as a result, might choose to perform a time-consuming scan of a complete table instead of just scanning an index. Having up-to-date statistics is important to ensure effective use of indexes.
Rebuilds all indexes in your database to ensure that the data is not fragmented.
When you perform any data modification operations (insert, update, delete) table fragmentation can occur. When this data modification affects the index, index fragmentation can also occur and information in the index can get scattered in the database. Fragmented data can cause SQL Server to perform unnecessary data reads during a query process and result in slow and inefficient performance. The greater the fragmentation, the less effective the index will be. Periodically rebuilding the index will remove fragmentation, reclaim disk space, and improve overall performance during a database query.
Checks the integrity of all objects in the CA ARCserve Backup database.
Databases can be corrupted by unusual events such as hardware failures, sudden loss of power, operating system failure, or improper operator action. It is important to periodically check the allocation, structural, and logical integrity of all objects in the CA ARCserve Backup database. Performing a database integrity check on a regular basis will detect and report any changes in the database that occurred since the last integrity check. Depending upon the size of your database, this can be a time-consuming task.
Reduces the size of the data and log files in the CA ARCserve Backup database and releases them back to the operating system.
Over time, your log files and data files can grow rapidly to a very large size and reduce the effectiveness of your database. When you control database size, performance will often improve and more users can access the database.
When you run ReduceDBSize you will need to enter the name of the database you want to shrink, along with the percentage of free space to leave in each file of the database. For example, if you've used 60 MB of a 100-MB database file, you can specify a shrink percentage of 25 percent. SQL Server will then shrink the file to a size of 80 MB, and you'll have 20 MB of free space.
Recommended: as needed
The results of the maintenance tasks will be saved to DBMaintenance.log, which is located in ARCserve Home directory.
for x32 bit servers
C:\Program files (x86)\CA\Arcserve Backup\LOG\
for x64 bit servers
C:\Program files\CA\Arcserve Backup\LOG
For ARCserve Database maintenance tasks via the ARCserve Manager gui, refer the article below :