Discover backup exec cloud backup, include the articles, news, trends, analysis and practical advice about backup exec cloud backup on alibabacloud.com
indicates that the backup created seven DAYS ago is deleted, that is, only the backup of the last seven DAYS is retained.Cd $ OUT_DIR # enter the backup storage directoryDATE = 'date + % Y _ % m _ % d' # obtain the current system timeOUT_ SQL = "$ DATE. SQL" # Name of the backup database fileTAR_ SQL = "mysqldata_bak_
:######################################## ######################################## ###! /Bin/sh/Etc/init. d/mysqld stop # stop MySql before performing backup to prevent data writing and backup errorsDate = 'date + % Y % m % d' # get the current dateDAYS = 7 # DAYS = 7 indicates that the backup created seven DAYS ago is deleted, that is, only the
NULL begin RAISERROR(N'validation failed. The backup information for the database database could not be found. ', -,1)EndRESTOREVerifyonly from DISK = @FullFileName with FILE = @backupSetId, Nounload, NorewindEXECMaster.dbo.xp_cmdshell'net use \\192.168.1.1\E$ 123456/user:192.168.1.1\user' EXECMaster.. xp_cmdshell@SQLStr IF(@FlagDel =1)BEGIN EXECMaster.. xp_cmdshell@SQLStr2END---picture explanationPerform a ba
have ' \ ' and not end with ' \ '
*/
If Right (@filename, 1) Begin
Select @sql_cmd = ' dir ' + @filename
EXEC @proc_result = Master. xp_cmdshell @sql_cmd, No_output
IF (@proc_result Begin
Select @flag = ' not exist ' * backup file does not exist * *
Return//* Exit Process * *
End
/* Create a temporary table that holds a result set consisting of a list of databases and log files contained in the
:/home/oracle/.bash_profile) * *
date= ' Date +%y_%m_%d ' # Get system Current date time days=7 #设置删除7天之前的备份文件 orsid= ' 192.168.150.214:1521/ORCL ' #Oracle数据库服务器IP , Port, SID orowner=ts #备份此用户下面的数据 Bakuser=ts #用此用户来执行备份, you must have permissions for the backup operation Bakpass=ts #执行备注的用户密码 Bakdir=/backup /oracledata #备份文件路径, you need to create a good Bakdata= $orowner "_" $date. DMP #备份数据库名称
Recently, the company has just built an integrated platform for Taian, the Integrated platform server installed SQL Server 2005, because there is no backup server, so can only off-site backup database. Find a lot of information on the Internet, the integration of their own.
First, open the SQL Agent service, and set to "automatic"
Second, backup
1, SQL Agent-
Let's look back at the first half of the data-related events in the IT field and re-deepen our understanding of the importance of data backup:January 2017 MongoDB Hacker Ransom incident, found some in the Internet users of MongoDB no protection measures, the attackers have deleted the database, and left a database called WARNING. "I have transferred your database in MongoDB, if you want your data, give me 0.2 bitcoins (about USD200). ”February 2017 Gitlab An exhausted system administrator who wo
What is icloud?
ICloud brings you the ideal cloud service that can store your music, photos, apps, calendars, documents, and more, and wirelessly push them to all of your devices.
How to register and activate icloud account
First step
Enter settings, select icloud
Second Step
Select "Create new Apple ID", please login directly.
Third Step
Store generally choose China, then point "next"
Fourth Step
Choose "Agree"
Fifth
Veeam 7 was released recently. First, we will introduce seven functions of Veeam 7.
07.Virtual Lab for replicas Reduce Risks and put into use copies>
SureReplica not only enables you to automatically verify each restore point in each replica, but also provides application objects (U-AIR) for testing, training, and troubleshooting purposes for the replica's virtual lab) and the fastest proxy-less recovery for sandbox.
06.Enhanced one-click File restoration Self-help recovery of virtual machines
Tags: style blog http color io os ar using for10 MySQL Database backup tutorials recommendedMySQL is the most famous open source database system in Dynamic Web development. If you use MySQL on your site, you should regularly back up your data to prevent it from being lost.This article will cover 10 tutorials for automating or manually backing up the MySQL database to see if there is a best way for you.1.backing up using MySQLDump(
is deleted, that is, only the backup of the last seven DAYS is retained.Cd $ OUT_DIR # enter the backup storage directoryDATE = 'date + % Y _ % m _ % d' # obtain the current system timeOUT_ SQL = "$ DATE. SQL" # Name of the backup database fileTAR_ SQL = "mysqldata_bak_1_date.tar.gz" # Name of the final database backup
files and only execute the command in seven days of the odd weekIf [$ flag-eq 1]; thenFor dir in $ {backdir_arr [*]}DoIf [-d $ dir]; then# Search for file data beyond 14 daysClean_arr = 'Find $ dir-type f-mtime + $ keep_time-exec ls {};'For cleanfile in $ {clean_arr}DoRm $ cleanfileDoneFiDoneFi
Crontab Configuration
The Code is as follows:0 5 ** 7 run the cleanup script
4. Others
Recently, When I backed up and restored mysql, I found that the view wa
last week onlyCd $back _dirFind-mtime +7-exec RM-RF {}\;2) TestChmod a+x/mysql_back.sql//Give script Execute permissionChattr +i/mysql_back.sql// in order to secure this script file lock, prohibit anyone to make changes/mysql_back.sql// Execute script3) Configuring Scheduled tasks into a production environmentCrontab-l0 2 * * */mysql_back.sql// 2 hours a day to execute the script.Exporting TablesImport a table into a text fileExport and import of
1. Set the backup directory on the backup server1.1 create a backupuser password for a specific user on the backup server 1231.2 create a directory backup under E: of the Backup Server
1.3 Share the Backup Directory, with the sha
]+ ' [email protected]SET @SQLSTR2 = ' DEL ' [email protected]BACKUP DATABASE @STRDATABASENAME to disk= @FULLFILENAME with INIT--Try to connect to the target machineEXEC MASTER. xp_cmdshell @STRCMDSHELL--Copy to target machineEXEC MASTER. xp_cmdshell @SQLSTR--Delete The local backup temp fileIF (@FLAGDEL = ' TRUE ') EXEC MASTER: xp_cmdshell @SQLSTR2GO(2) Source s
;The archive created for all versions of the database is backed up. The storage path is 'config/gitlab. Yml' in gitlab'The file name is 'Your timestamp;_gitlab_backup.tar '.'''Bundle exec rake gitlab: backup: create RAILS_ENV = production'''For example:'''Dumping database tables:-Dumping table events... [DONE]-Dumping table issues... [DONE]-Dumping tab
ld_library_path= $ORACLE _home/lib: $ORACLE _home/rdbms/lib:/lib:/usr/lib:/usr/local/libExport Lang=cExport Nls_lang=american_america. Al32utf8#以上代码为Oracle数据库运行账号oracle的系统环境变量设置, you must add, otherwise crontab task schedule cannot be executed.Datetime= ' Date +%y_%m_%d ' #当前系统时间Days=7 #删除7天前的备份数据sOrsid= ' 127.0.0.1:1521/ORCL ' #oralce连接信息Orowner=oracle # Back up the data below this userBakuser=oracle #用此用户来执行备份, you must have permissions to the backup
To add a key (in order to back up an SSH project) to the Ditlab container cd/home/git/gitlabbundle exec rake gitlab:backup:create rails_env= in the personal user settings before actually applying the settings Production Cd/home/git/gitlabbundle exec bin/rake gitlab:backup:restore rails_env=production chown git:git-r/opt/ Gitlab-7.11.4-0/apps/gitlab/repositories above for self-time content, the following is
:/home/oracle/.bash_profile
Date= ' Date +%y_%m_%d ' #获取系统当前日期时间Days=7 #设置删除7天之前的备份文件Orsid= ' 192.168.0.198:1521/ORCL ' #Oracle数据库服务器IP, Port, SIDOrowner=osyunwei #备份此用户下面的数据Bakuser=osyunwei #用此用户来执行备份, you must have permissions to the backup operationBakpass=osyunwei #执行备注的用户密码Bakdir=/backup/oracledata #备份文件路径, it needs to be created in advance.Bakdata= $orowner "_" $date. DMP #备份数据库名称Baklog= $orowner "_"
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.