Database Maintenance...
Posted: 22 Jul 2011, 07:57
Morning All,
So just a quick question for all you database freaks out there and this applies MSSQL and Exchange 2010 which as far as my understanding goes is a MSSQL database anyway...
What tasks need to be done to maintain performance? What are the best best practices regarding this? And I take it these sort of operations should not be done while the database is live?
My reason for asking (and I expect some flak regarding this) is because we dont have any Maintenance tasks for our live Production database and our Exchange 2010 database and I suspect as well as our SAP database. So yeah I just need some tips regarding database maintenance but I also need know the risks involved.
/This is what happens when ones IT Department is stretched to thin...
So just a quick question for all you database freaks out there and this applies MSSQL and Exchange 2010 which as far as my understanding goes is a MSSQL database anyway...
What tasks need to be done to maintain performance? What are the best best practices regarding this? And I take it these sort of operations should not be done while the database is live?
My reason for asking (and I expect some flak regarding this) is because we dont have any Maintenance tasks for our live Production database and our Exchange 2010 database and I suspect as well as our SAP database. So yeah I just need some tips regarding database maintenance but I also need know the risks involved.
/This is what happens when ones IT Department is stretched to thin...