cancel
Showing results for 
Search instead for 
Did you mean: 

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

jdewing
Level 4

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?

1 ACCEPTED SOLUTION

Accepted Solutions

JesusWept3
Level 6
Partner Accredited Certified

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

https://www.linkedin.com/in/alex-allen-turl-07370146

View solution in original post

2 REPLIES 2

JesusWept3
Level 6
Partner Accredited Certified

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

https://www.linkedin.com/in/alex-allen-turl-07370146

Arjun_Shelke
Level 6
Employee Accredited

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