yoursqldba的 翻译 (六) 在运行下面这个存储过程之前，先部署好yoursqldba，执行yoursqldba_installorupdatescript.sql. 脚本。然后运行下面的存储过程进行配置您的yoursqldba 这个存储过程在sqlserver 代理里创建两个任务，这些任务的描述都包含在maint.you
yoursqldba的翻译(六)在运行下面这个存储过程之前，先部署好yoursqldba，执行yoursqldba_installorupdatescript.sql. 脚本。然后运行下面的存储过程进行配置您的yoursqldba
这个存储过程在sqlserver 代理里创建两个任务，这些任务的描述都包含在maint.yoursqldba_domaint存储过程里
任务一：在午夜执行yoursqldba_fullbackups_and_maintenance 作业，这个作业的用途是执行每日维护包括完整备份数据库
任务二：每15分钟执行yoursqldba_logbackups 作业，这个作业的用途是备份事务日志
yoursqldba创建一个数据库邮件profile 命名为yoursqldba_emailprofile
这个profile里有一个帐户：名为.@yoursqldba.com
    是你的服务器的计算机名.
    是你的sqlserver实例名字
yoursqldba还会创建一个sqlserver代理操作员，命名为yoursqldba_operator ，这个操作员包含了@email参数
yoursqldba会配置警报根据你配置的数据库邮件，发送警报到你的邮件地址
yoursqldba会改变sqlserver实例默认的sql errorlog的数量，默认只有7个，这样就能够有更长的errorlog历史可以追查
initial setup
updated : 2010-10-06
before to run it, deployed yoursqldba solution by running the script yoursqldba_installorupdatescript.sql.
then run this procedure from yoursqldba database.
sample :
1 exec yoursqldba.install.initialsetupofyoursqldba 2 @fullbackuppath = 'c:\isql2005backups' -- full backup path destination 3 , @logbackuppath = 'c:\isql2005backups' -- log backup path destination 4 , @email = 'myadmin@mydomain.com' -- email recipients (or distribution list) 5 , @smtpmailserver = 'mymailserver' -- mail server that accept smtp mail 6 7 , @consecutivefailedbackupsdaystoputdboffline = 0000 8 -- maximum number of consecutive days of failed full backups allowed 9 -- for a database before putting that database (offline). 10 -- you must choose a value between 4 and 9999. 11 -- important: your can read the explanations in the initialsetupofyoursqldba page 12 -- for using the @consecutivefailedbackupsdaystoputdboffline parameter.
click here to get the full description of the call to the procedure install.initialsetupofyoursqldba.
the procedure create two tasks in sql server agent that invokes the maint.yoursqldba_domaint procedure. 
at midnight : yoursqldba_fullbackups_and_maintenance : perform daily maintenance including full backups of name :
every 15 minutes around the clock : yoursqldba_logbackups : does log backups
it creates a database mail profile named yoursqldba_emailprofile which contains a account named as
    .@yoursqldba.com
    is the name of the server.
    is the name of the instance if it is not the instance by default.
it creates an sql server agent operator named yoursqldba_operator which contains the value of the @email parameter.
it configures sql server agent alert system to have yoursqldba_emailprofile.
it modifies log archive number limit on sql server instance, so it is possible to have a longer sql server error logs history