Place the following file in the System32 directory,
Then, open it with a note.
Backupsql.bat
will be inside the
"The location of the data directory for the e:sql2000 database *.*"
Change to your own SQL2000 data directory, such as
"E:program FilesMicrosoft SQL servermssqldata*.*"
And then the inside of the
"The location of the data directory for the E:mysql database *.*"
Change to your own MySQL data directory, such as:
"E:program filesmysqlmysql Server 5.0data*.*"
After saving,
You can schedule tasks in the Control Panel on the server,
Add a scheduled task, call this backupsql.bat to run a scheduled backup. The files generated by the backup are saved by default in E disk, and you can modify the location by modifying the Backupsql.bat.
@echo off
C:
CD "C:Program Fileswinrar"
net stop MSSQLServer
Winrar.exe a-ag "-[yyyy-mm-dd-hh-mm-ss]"-k-r-s-ibck-inul "e:sql2000 backup generated files. rar" "e:sql2000 location of the data directory in the database *.*"
NET start MSSQLServer
net stop Mysql
Winrar.exe a-ag "-[yyyy-mm-dd-hh-mm-ss]"-k-r-s-ibck-inul "E:mysql backup generated files. rar" "E:mysql location of the data directory in the database *.*"
net start Mysql