Database backups
Archive Shuttle recommends recommend that you perform regular backups of the Archive Shuttle Directory Database and the Item Databases. These databases contain important data relating to the configuration of the migration as well as the progress, down to the individual item level.
|
|
NOTE: It is a best practice to perform nightly full backups of each of the databases. This will ensure the shortest recovery time. |
Other backup types are supported; however, it may lengthen the recovery time if a database restore is needed.
Details for configuring database backups for specific versions of SQL Server is outside the scope of this document.
Index rebuilds and statistics updates
Archive Shuttle recommends that you perform weekly index rebuilds on the Archive Shuttle Directory Database and each Item Database. This is particularly important when Item Gathering is being performed where a large amount of data is being added to the Item Databases.
Archive Shuttle contains a new Index Fragmentation page in the Admin Interface. This page shows the current levels of Index Fragmentation in the Archive Shuttle databases. This page also color-codes the rows to help highlight any potential problems, as follows:
Yellow Page count > 1000, average fragmentation 10-30%
Red Page count > 1000, average fragmentation >30%
|
|
NOTE: Perform online Index Rebuilds in SQL Server weekly. |
Details for configuring Index rebuilds for specific versions of SQL Server is outside the scope of this document. It is important to note that there are editions of SQL Server where the Index rebuild operation can be performed with the index online, and there are editions of SQL Server where the Index rebuild will cause the index to be made offline while the operation is performed. According to Microsoft documentation (referenced below), online index operations can be performed in SQL Server Developer Evaluation and Enterprise Editions.
http://technet.microsoft.com/en-us/library/ms186880(v=sql.105).aspx
If the edition of SQL Server in use for the migration does not support online index rebuilds, make sure to schedule the rebuild operations when there is a low level of activity from Archive Shuttle.
It is also recommended to do the Update Statistics maintenance task, following an index rebuild.
|
|
NOTE: In many environments performance has been seen to dramatically increase if index rebuild and statistics updates are performed daily. Check the index fragmentation page frequently to see if this will help in a specific environment. |
About Us
Quest creates software solutions that make the benefits of new technology real in an increasingly complex IT landscape. From database and systems management, to Active Directory and Office 365 management, and cyber security resilience, Quest helps customers solve their next IT challenge now. Around the globe, more than 130,000 companies and 95% of the Fortune 500 count on Quest to deliver proactive management and monitoring for the next enterprise initiative, find the next solution for complex Microsoft challenges and stay ahead of the next threat. Quest Software. Where next meets now. For more information, visit www.quest.com.
Contacting Quest
For sales or other inquiries, visit www.quest.com/contact.
Technical Support Resources
Technical support is available to Quest customers with a valid maintenance contract and customers who have trial versions. You can access the Quest Support Portal at https://support.quest.com. The Support Portal provides self-help tools you can use to solve problems quickly and independently, 24 hours a day, 365 days a year. The Support Portal enables you to:
·Submit and manage a Service Request
·View Knowledge Base articles
·Sign up for product notifications
·Download software and technical documentation
·View how-to videos
·Engage in community discussions
·Chat with support engineers online
·View services to assist you with your product