Note: This section only applies when using Microsoft SQL as the Arcserve Backup database.
You should rebuild the SQL Server index periodically to keep the index size manageable and at optimal performance. The best practice is to rebuild the index once or twice per month, or when the Arcserve database performs slowly.
The process of updating the SQL Server indexes can take a lot of time. If you do not have enough time to update all the indexes, you should update the key indexes: IX_astpdat_1, IX_astpdat_2, X_astpdat_3, K_pathname, and PK_filename. These indexes play an important role and affect the browsing speed in the Restore Manager and Database Manager.
For information about how to rebuild the SQL Server indexes, see the Microsoft SQL Server documentation.
Copyright © 2015 |
|