SQL Server maintenance script before upgrading EV 10 to v11 ?

[John_Santana]

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.

[JimmyNeutron]

You need to do a full backup of all your EV databases.

[AndrewB · Accepted solution]

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

[John_Santana]

@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 ?

[AndrewB]

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