YourSQLDba的翻译(六)

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 :

<span> 1</span> <span>Exec</span><span> YourSQLDba.Install.InitialSetupOfYourSQLDba 
</span><span> 2</span>   <span>@FullBackupPath</span> <span>=</span> <span>'</span><span>c:\iSql2005Backups</span><span>'</span>       <span>--</span><span> full backup path destination </span>
<span> 3</span> , <span>@LogBackupPath</span> <span>=</span> <span>'</span><span>c:\iSql2005Backups</span><span>'</span>   <span>--</span><span> log backup path destination </span>
<span> 4</span> , <span>@email</span> <span>=</span> <span>'</span><span>myAdmin@myDomain.com</span><span>'</span>              <span>--</span><span> Email recipients (or distribution list) </span>
<span> 5</span> , <span>@SmtpMailServer</span> <span>=</span> <span>'</span><span>myMailServer</span><span>'</span>             <span>--</span><span> Mail server that accept SMTP mail </span>
<span> 6</span> 
<span> 7</span> , <span>@ConsecutiveFailedbackupsDaysToPutDbOffline</span> <span>=</span> <span>0000</span> 
<span> 8</span>                            <span>--</span><span> Maximum number of consecutive days of failed full backups allowed </span>
<span> 9</span>                            <span>--</span><span> for a database before putting that database (Offline). </span>
<span>10</span>                            <span>--</span><span> You must choose a value between 4 and 9999. </span>
<span>11</span>        <span>--</span><span> Important: Your can read the explanations in the InitialSetupOfYourSQLDba page </span>
<span>12</span>        <span>--</span><span>            for using the @ConsecutiveFailedbackupsDaysToPutDbOffline parameter. </span>

 

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