SQL Server DBA Checklists ( Daily, Weekly & Monthly )

Daily

    Check system uptime (just in case I need to check anything as a DBA)
    Check the last backup
    Check the transaction log backups
    Check the status of SQL Jobs
    Check the average CPU usage for the last 24 hours (or 1140 mins)
    Check the database status
    Check the SQL error log and event viewer

Weekly

    Check MSDB backup history
    Check to see when the last time CheckDB and Update stats was run
    Check index fragmentation
    Check index stats (reads vs writes etc)
    Check for IO bottlenecks

Monthly

    Check missing indexes
    Check indexes that are no longer used
    Estimate the Disk usage by MDF file growing

****************************************************************************
 DAILY CHECK LIST:

    Backups
        Check for backup emails
        How long did the backup take to run (database backup duration)
        Verify that all databases are being backed up according to a maintenance plan
    Disk free space. Note significant variations from previous check. Log files may be affected dramatically by monthly jobs
   
Job failures. Filter job activity for failures
   
System checks. Look in sql logs for any critical errors.
        Application logs
    Performance
        Check performance statistics on all servers
        Check that counters are in normal range on all production servers
    Connectivity
        Verify the customer application can get data from the database
        Verify acceptable speed of access data
    Replication. Verify that the each publication and distributor is running for each subscription.
    Logshipping :Check the all jobs which should be run on as per the scheduled and check the availability space drives which is residing the T-log backup files.

    Mirroring : check the stats of mirroring.