Basic management scipts that you run in your database / instance?

Question

What kind of basic management/audit scripts do you run in your databases or in an instance? There may be lots of them, but I would like to know (get hints) what kind of task would be most valuable when managing databases or an instance. And also what kind of reporting do you have from your databases (in a management perspective)?

Answer 1

I'd start with maintenance plans

• index maintenance
• statistics maintenance
• integrity checks
• backups

I'd worry about reports later once you have the basics in place...