YourSQLDba的翻译(三)

YourSQLDba的翻译(三)

自动完整备份和定期事务日志备份

执行更新统计信息（默认一个星期更新一次）

自动选择重组或重建索引当遇到索引碎片

检查数据库完整性DBCC CHECKDB

保持一个最新的MSDB数据库备份，MSDB保留了所有备份历史（在完整或日志备份里链里的结尾）

清除历史日志（备份，sql agent，sql 维护）

重新设置SQL ERROR LOG的大小，保留30个ERRORLOG文件

提供简明的存储过程让你去做手工备份，复制数据库，和还原数据库

调度sql agent去做维护任务

配置数据库邮件去报告维护情况

发送EMAIL报告维护任务的执行情况

发生异常邮件报告维护任务遇到的问题

立即禁用数据库当检查数据库完整性的时候遇到问题 DBCC CHECKDB

当连续3次备份数据库失败就禁用数据库，手动备份数据库可以重置失败次数

当备份数据库到网络位置的时候自动连接网络驱动器，当数据库启动的时候自动重新连接网络驱动器

-------------------------------------------------------------------------------------------

你的意见对我们很重要
你有什么不满意对YourSQLDba？YourSQLDba是可定制的，不需要改变代码
而且也是开源的。任何的建议都欢迎。我们非常乐意接受你的部署建议
如果你已经创建了脚本或者存储过程来调整您的YourSQLDba并且你想在社区分享他们
你可以联系我们，我们会把您的功能添加到YourSQLDba

 

What it does...
  

Updated: 2011-04-01

Automate full backups and recurrent log backups.
Perform update statistics (spread all of them over a specified period of time, by default a week)
Selectively reorganize or rebuild index that show a fragmentation thresold
Check database integrity
Keep an up-to-date backup of MSDB which record all backup history (at the end of each full or log backup cycle)
Clean-up history log (backup, Sql Agent, Sql maintenance)
Recycle SQL Server error log every day (keep up to 30 archives)
Provides simplified sp utilities to do manual backup, duplicate database, and restore database.
Schedule agent task for maintenance
Configure database mail for maintenance reporting
Send e-mail that regular notify maintenance activity
Send exceptional e-mail for notifying problematic maintenance  issues
Disable immediately databases with integrity problem
Disable databases which failed to be backup more than 3 consecutives times (manual backup can reset the failure count)
Connect network drives visible to database engine for backup purposes, and make them auto-reconnect at startup.
 

Your opinion is very important to us

Something you don't like ?  YourSQLDba is customizable without changing the code, and it is also open source.  Any suggestions or needs expressed are welcome.  We are really very interested to receive your development suggestions for YourSQLDba.

If you have created scripts or stocked procedures to augment YourSQLDba and you want to share them with the community, you can contact us so that we would add them to YourSQLDba.

 

转载于:https://www.cnblogs.com/lyhabc/archive/2013/06/12/3132527.html