What sort of SQL maintenance is needed?

What sort of SQL maintenance is needed?

Hi Guys,

I've noticed we've had ServiceDesk installed for just on a year, and we've never done any sort of SQL maintenance plan on the database.

Can anyone tell me if there is a best practise guide for running maintenance on the ServiceDesk MSSQL database? Things like re-indexing etc.

Has anyone set up a maintenance plan for their SD database? If so how'd you go?

Cross fingers for me people, I'm upgrading from 7018 to 7504 tonight. Hopefully things go smoothly!

Cheers!