Mandatory Database Tasks [GL OG]
Please execute regularly maintenance jobs for your production database system. Do not forget the database and transaction log backups.
Please do not forget the database backups of your user databases and the system databases master and msdb.
If you are in the situation that you must restore your database, it is not necessary to save the *.mdf and *.ldf files via disk snapshot.
If your database is in the recovery mode full, you must execute transaction log backups. Otherwise, the logfile of the database will be growing until next transaction log backup. It is often that the disk runs out of space. Then the database cannot work and will wait.
It is important for your production database, that you execute a defragmentation for the indices where it is necessary.
Rebuild by a fragmentation more than 30%.
Reorganize by a fragmentation under 30%.