What kind of database maintenance operations you should be doing when you are DBA? You should have better understanding on the terms in managing the Database platform at your end, without proper information it is very hard to say you are managing your platform effectively. Think about DBCC checks, backups and database maintenance tasks and list of tasks as follows: Hardware - think about maintenance Integriy checks for data and environment Database files - place them for better performance Optimizations...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/perftune/archive/2007/12/03/2846.aspx