Daily jobs

  • Hi every one i'm new to this world.

    Can any one tell me the exact Daily roles of the SQL DBA.

    regards,

    visu

  • Check for Database Usage(Data and Log Size).

    Check for Table space usage (Most used tables)

    Check for errors logs for SQL Server

    Check for Memory usage and paging for SQL Server

    Check the time taken for backups

    Check for Jobs failed

    Check for logins failed(Audit)

    Check for new objects created

    Check for new logins created

    with;

    Creation & Restoration of databases

    Recovery of data loss....

    These are some of the activities that DBA should perform on Daily basis.

    Rd,

    Deepali

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply