net stop sqlserveragent net stop mssqlserver echo.wscript.sleep(50000)>s.vbs cscript //nologo s.vbs del s.vbs net start mssqlserver net start sqlserveragent
收縮sqlserver數據庫，清空日志文件
復制代碼 代碼如下:
DUMP TRANSACTION [數據庫名] WITH NO_LOG BACKUP LOG [數據庫名] WITH NO_LOG DBCC SHRINKDATABASE([數據庫名])
mysql數據庫下實現自動備份并用winrar壓縮實現的批處理和php文件
復制代碼 代碼如下:
FOR /D %%i IN (*) DO D:/php/php5/php.exe -q D:/php/php5/backup.php %%i
backup.php
復制代碼 代碼如下:
<?php if ($argc != 2 || in_array($argv[1], array('--help', '-?'))) { ?> backup Ver 0.01, for Win95/Win98/WinNT/Win2000/WinXP on i32 Copyright (C) 2000 ptker All rights reserved. This is free software,and you are welcome to modify and redistribute it under the GPL license PHP Shell script for the backup MySQL database. Usage: <?php echo $argv[0]; ?> <option> <option> can be database name you would like to backup. With the --help, or -? options, you can get this help and exit. <?php } else { $dbname = $argv[1]; $dump_tool = "D://php//mysql//bin//mysqldump.exe"; $rar_tool = "D://program//winrar//rar.exe"; $dateml=date("Ymd"); $yesday=date('Ymd' , strtotime('-6 day')); @exec("md F://sqldata//mysqlbak//$dateml"); @rmdir("F://sqldata//mysqlbak//$yesday"); //@exec("$dump_tool --single-transaction --opt -u root -pxzqcABCD986 $dbname > ./$dbname.sql"); //@exec("$rar_tool a -ag_yyyy_mm_dd_hh_mm F://sqldata//mysqlbak//{$dateml}//$dbname.rar $dbname.sql"); @exec("$rar_tool a -ag_yyyy_mm_dd_hh_mm F://sqldata//mysqlbak//{$dateml}//$dbname.rar D://php//mysql//data//$dbname"); @rmdir($dbname); echo "Backup complete!"; } ?>
