将下面的内容保存为sqlreboot.bat,然后添加到计划任务里，就可以实现一段时间后重启sqlserver服务器了，防止sqlserver经常占用内存过高，导致网页无法打开数据。
复制代码 代码如下:
netstopsqlserveragent
netstopmssqlserver
echo.wscript.sleep(50000)>s.vbs
cscript//nologos.vbs
dels.vbs
netstartmssqlserver
netstartsqlserveragent
收缩sqlserver数据库，清空日志文件
复制代码 代码如下:
DUMPTRANSACTION[数据库名]WITHNO_LOG
BACKUPLOG[数据库名]WITHNO_LOG
DBCCSHRINKDATABASE([数据库名])
mysql数据库下实现自动备份并用winrar压缩实现的批处理和php文件
复制代码 代码如下:
FOR/D%%iIN(*)DOD:phpphp5php.exe-qD:phpphp5backup.php%%i
backup.php
复制代码 代码如下:
<?php
if($argc!=2||in_array($argv[1],array('--help','-?'))){
?>
backupVer0.01,forWin95/Win98/WinNT/Win2000/WinXPoni32
Copyright(C)2000ptkerAllrightsreserved.
Thisisfreesoftware,andyouarewelcometomodifyandredistributeit
undertheGPLlicense
PHPShellscriptforthebackupMySQLdatabase.
Usage:<?phpecho$argv[0];?><option>
<option>canbedatabasenameyouwouldliketobackup.
Withthe--help,or-?options,youcangetthishelpandexit.
<?php
}else{
$dbname=$argv[1];
$dump_tool="D:phpmysqlbinmysqldump.exe";
$rar_tool="D:programwinrarrar.exe";
$dateml=date("Ymd");
$yesday=date('Ymd',strtotime('-6day'));
@exec("mdF:sqldatamysqlbak$dateml");
@rmdir("F:sqldatamysqlbak$yesday");
//@exec("$dump_tool--single-transaction--opt-uroot-pxzqcABCD986$dbname>./$dbname.sql");
//@exec("$rar_toola-ag_yyyy_mm_dd_hh_mmF:sqldatamysqlbak{$dateml}$dbname.rar$dbname.sql");
@exec("$rar_toola-ag_yyyy_mm_dd_hh_mmF:sqldatamysqlbak{$dateml}$dbname.rarD:phpmysqldata$dbname");
@rmdir($dbname);
echo"Backupcomplete!";
}
?>