11-22-2015 04:51 PM
Hi All,
Before upgrading the EV v10 to version 11, so I wonder what sort of SQL Server maintenance task that I need to complete before hand to ensure smooth upgrade ?
Note:
I'm now using
Microsoft SQL Server 2008 R2 Enterprise Edition (64-bit) (SP2) - 10.50.4000.0 I tried to look into: https://technet.microsoft.com/en-us/library/ms137718(v=sql.120).aspx but not sure which table that I need to focus on.
Thanks.
Solved! Go to Solution.
11-22-2015 08:39 PM
hi john,
the two sql maintenance tasks which would be the most beneficial are reorganize (or rebuild) the indexes and update statistics. there's a technote about it in general. sql maintenance is something you should do regularly, not just before an upgrade.
http://www.veritas.com/docs/000040169
11-22-2015 07:28 PM
You need to do a full backup of all your EV databases.
11-22-2015 08:39 PM
hi john,
the two sql maintenance tasks which would be the most beneficial are reorganize (or rebuild) the indexes and update statistics. there's a technote about it in general. sql maintenance is something you should do regularly, not just before an upgrade.
http://www.veritas.com/docs/000040169
11-24-2015 07:49 PM
@AndrewB,
So yes, I'm interested to know if the Rebuild Indexes and Update Statistics task
Can be done nightly without causing any outage to the EV Database ?
11-24-2015 11:10 PM
yes, these sql maintenance operations can be done "online" which does not require any outage to EV. but you should schedule the maintenance at times when your archiving tasks are not running and when backups are not running