YourSqlDba

Project Description
T-Sql Database script that automate database maintenance using SQL Agent an DB Mail. Performs optimizations (index, statistics), integritry check, databases backups (complete and tx logs).

This project is all based on a big T-SQL Scripts that setup a maintenance database which contains stored procedures for SQL Server Maintenance. The project is delivered through an HTML Help file (see our site www.grics.qc.ca/Yousqldba for problem resolution when displaying Html Help file in Vista and Windows 7). A link in the Html Help home page allows opening of the script. For more details go to http://yoursqldba.codeplex.com/wikipage?title=YourSQLDba: My new blog spot (PelSql)

Since it is a script it is very easy to setup and upgrade. The script is written as a cumulative service pack, so it is easy to upgrade maintenance procedures to the latest version. Just open the latest script version an run it. Only initial setup requires to launch a stored procedure to defines default backup directory, e-mail recipients for mainteance, and a SMTP Server for Database Mail. This first call creates also 2 jobs in SQL Server Agent.

It relies only on SQL Server Agent to run maintenance. It creates 2 jobs only, each one with only one step which is a call to the T-SQL maintenance stored procedure. First job perform the big daily maintenance, second performs continuous log backpus. In both case job frequency is based on a regular SQL Agent Job schedule. It set up Database Mail for communication purpose with DBA, or tech. people who are responsible for their data. Extensive logging of SQL instruction issued from database maintenance allows easy diagnosis in case of problem and e-mail keep IT people informed of regular maintenance.

Some parameters allows flexibility for dynamic database selection, backup retention, backup destination etc etc.

The default parameters values provided in setup are good startup for those who are not sure how to perform database maintenance.

This script makes easy to have proper maintenance on sites where there is no DBA. It makes it easy to setup for application support teams. However, a growing number of experienced DBA find it very useful and reliable for their daily manitenance activity.

YourSqlDba is going to be a long lasting project, as it is sponsored by Société GRICS, my employer. Your SqlDba is a mean to have proper maintenance of databases on which our software run, so our customers don't run into problems because of improper database maintenance. If my name is the only developer on Codeplex site we are in fact 3 experience sql developpers. YourSqlDba is much more that just what I say here, time lacks for documentation outside of the one supplied in the HTML Help file.