Video Screencast Help

Should I stop EV services or place EV in the Backup Mode during SQL database Maintenance?

Created: 13 Mar 2013 • Updated: 19 Mar 2013 | 2 comments
This issue has been solved. See solution.

Do I need to stop the Enterprise Vault services when running SQL Maintenance such as database shrink and re-indexing?  Can I just place Enterprise Vault in the Backup mode instead of stopping the services?

Operating Systems:

Comments 2 CommentsJump to latest comment

JesusWept3's picture

Backup mode is fine for Reindexing, however there are some indexes that may not allow you to index rebuilds when the index is online, in which case the database would have to be taken offline and if you do that EV Services would need to be stopped, else they will just crash or cause other errors.

As for shrinking, theres really no point shrinking databases, SQL Server will use what white space there is when it needs to add new data and what you may end up doing is impacting performance when SQL Server starts to autogrow the SQL Database to a size you shrank it from to begin with

SOLUTION
Advisor's picture

If you have high Logical and extent scan fragmentation on specific tables/indexes then some times running SQL maintenance might not give you expected results. In many cases I have observed that stopping EV services while running maintenance does help in getting fragmentation levels down