03-13-2013 08:09 AM
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?
Solved! Go to Solution.
03-13-2013 09:55 AM
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
03-13-2013 09:55 AM
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
03-14-2013 12:59 AM
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