seagate automatic backup

Method 1: JobSteps for automatic backup in SQL Server 2005 database:1. Open the SQL Server Management Studio http://www.111cn.net2. Start the SQL Server proxy3. Click Job> create job.4. Enter the job name in "regular"5. Create step, type select T-SQL, enter the following statement in the following command The code is as follows:Copy code DECLARE @ strPath NVARCHAR (200)Set @ strPath = convert

Scheduled backup of Web site data The code is as follows Copy Code #!/bin/bashPath=/bin:/usr/bin:/sbin:/usr/sbin;Export PATH;Tar zcvf/web/backup/bak.$ (date +%y-%m-%d). tar.gz/web/www/www.111cn.netFind/web/backup-type f-mtime +2-exec rm {}; Second line: Import environment variables The third line, the designated directory t

1 * * 5 sh/root/back.sh Set up 5 1 o'clock in the morning 30 days a week to perform a script backup and send mail. Specific crontab usage can refer to here (Linux vps/server crontab scheduled task settings and crontab writing format). V. BACKUP DATABASE Script Summary 1, the current script is relatively simple, but the function can be impl

'==================== Lan File Automatic Backup vbs script ============================ ' 'Condition: 10.97.1.x xcopy/xcopy belongs to Adminstrator. 'The directory where the shared backup file is located gives xcopy users full control! 'After running, there are two processes in the management process: wscript. EXE , Ping.exe 'Use the date as the log file name

Mysql automatic shell backup in linux #! /Bin/bash # mysql backup script # backup principle: #1 # list all databases; #2 # list each table using each database, in addition to the specified ignored database; #3 # Use mysqldump to export each table to a file: host name, year, month, day, database, or table. mysqldump. SQ

There are a lot of methods for automatic MySQL backup under windows on the Internet, but there are not a few that can be used, some of which are still very complicated and difficult to operate. We all know that MSSQL itself comes with scheduled tasks that can be used for automatic backup,But how do we have

1. Implementing Local Automatic database backup is simple: 1. log in as root 2. scheduled tasks (automatically executed at every day/usr/bin/mysqlbackup) Crontab 0 :30 ***/usr/bin/mysqlbackup 3. Write an automatic backup database script Vi/usr/bin/mysqlbackup #! /Bin/bash Mv/home/.../db_bak5.tgz/home/.../db_bak6.tgz Mv

Original: http://www.cnblogs.com/heekui/archive/2007/01/25/629972.aspx Author: Web. Internet wave. Blog Daily automatic VSS backup The younger brother is working as a configuration administrator in the project. Of course, I have to handle the task of backing up VSS. Otherwise, the work of the younger brother may fail due to any natural or man-made disasters.In the past, the frequency of backing up VSS

We use the automatic batch processing program to back up the data. It can generate a backup file on a given day and save the data on a daily basis to a corresponding directory, it should be implemented in combination with windows scheduled tasks. Method 1 CodeBackup The Code is as follows: Copy code @ Echo off setlocal ENABLEEXTENSIONS: ---------- Configuration item ----------: Path

: oraclebackup"/dmp/OA *. log/d-10/c "cmd/c del @ path" Echo is backing up the Oracle database. Please wait ...... Exp user/password @ orcl file = E:/oraclebackup/dmp/OA _ % date :~ 0, 4% % date :~ 5, 2% % date :~ 8, 2%. dmp log = E:/oraclebackup/log/OA _ % date :~ 0, 4% % date :~ 5, 2% % date :~ 8, 2%. log owner = (jasoa_doc) Echo task completed! After that, change the txt extension of the notepad to bat. Double-click oraclebackup. bat to test whether the b