SQL Server Performance

Backup and Disaster Recovery Procedures

Discussion in 'SQL Server 2005 General Developer Questions' started by reddy71752, Dec 1, 2008.

  1. reddy71752 New Member

    Hi Friends,
    I need to write a script to check the following things
    1. Type of backups using for all databases
    2. Need to check whether system databases are include in backup plan or not
    3. Access to Backup files---Restrict restore permissions to DBAs and db_owners.
    4. replication agent runs under SQL Server Agent account
    5. Prevent SQL injection by validating all user input before transmitting it to the server.
    6. Check the Audit level in SQL Server
    Thanks,
    Reddy

Share This Page