ea servers back up

Label:Today made a very annoying thing, accidentally put a 40 more g of the database log files deleted, and before the deletion I made a log in, dead or alive can not attach to the server has been prompted multiple logs cannot be automatically created, wasted a night of my time, and then constantly Google, Finally in a foreigner's blog found a few statements, directly, thank him on the way to record. 1 2 3 4 5 6 7 8 9 10 11 USE [master] GO -- Method 1: I use this method EX

Setting up an FTP server has always put security first, especially with FTP servers built with tools like IIS. If the improper setting suffers a malicious attack, the entire server system crash is not alarmist! Therefore, it is necessary to take reasonable and comprehensive safety management. Let's start with the security of IIS. IIS, starting with the NT system kernel, has become an important information release carrier, but its unavoidable vulnera

The business value of a precise enterprise mail is often more than a needle in a haystack fuzzy positioning type of mass is much higher, the message sent out, the enterprise most concerned about the first is its read volume, ordinary Enterprise mailbox in the mail sent out after the helpless, Turbomail Mail Server Mass report to the enterprise group of each message implementation tracking statistics, can be implemented to specific accounts, and can show the number of sending failures and email

actually borrows the name of the Libeventstruct event, because each instance of the event class corresponds to an object of Libeventevent. The focus we need to focus on is Procedure and the Client class. Procedure class There are two key features of the Procedure class: Each object has a LIBCO, which has its own independent contextual information that can be used to write a separate server process (procedure); Subclasses of Procesure ca

This is a complete SQL statement exec sp_dropserver ' CSJ ',' droplogins ' --after the operation, delete the "CSJ" Connection name 2.OPENROWSET functionYou need to change a setting on the primary server first, right-click on the primary server-aspectYou need to change the Adhocremotequeriesenabled property to True, which is false by default--------* * * You can also use the statement to complete the above operation[SQL]View PlainCopy Use master; GO exec sp_config

Searching the Internet for cross-server queries, presumably linked server (pre-storage connection mode and ensure connectivity) and OpenDataSource (written in the statement, the portability of strong). Depending on the function used, the performance difference is obvious ... Although very simple, but LZ was pit for a few days only to find, ashamed.1. Linked ServerVery useful function, add the method if there is a problem can contact LZ alone, not very complex ~Use method One:1 Select * from Lin

zk_env VARCHAR (+) not NULL; Delete a fieldALTER TABLE user DROP COLUMN new2 Modify the type of a fieldALTER TABLE user MODIFY New1 VARCHAR (10);To modify the name of a field, be sure to re-specify the field's typeALTER TABLE user change new1 new4 int; Change Column Name Alter table student change Physics Physisc char (Ten) not null; You can add comments to a tableALTER TABLE ' table_name ' COMMENT ' notes ';Adding comments to a field also applies to modifyingALTER TABLE ' table_name ' change

Tags: Service login sel up-down Link Server query query statement serverMethod One: 1. Create a linked server Linked server local name--linkserver destination address--192.168.8.11 exec sp_addlinkedserver ' linkserver ', ', ' SQLOLEDB ', ' 192.168.8.11 ' 2, log on to the linked server Linked server local name--linkserver login--sa Password--11111 exec sp_addlinkedsrvlogin ' linkserver ', ' false ', NULL, ' sa ', ' 11111 ' 3, Query SELECT * from Linkserver. database. Table Method Two: A database

Server A, Server BSELECT * FROM (Select a.ID as hid,a.subjectid as hsubjectid,b.id as lid,b.subjectid as lsubjectid,c.* from OPENROWSET (' Msdasql ',' Driver={sql Server}; Server=a; Uid=sa; pwd=*** ',DbName) as a left join OPENROWSET (' Msdasql ',' Driver={sql Server}; Server=b; Uid=sa; pwd=*** ',DbName) as B on a.subjectid = B.subjectidLeft join OPENROWSET (' Msdasql ',' Driver={sql Server}; Server=b; Uid=sa; pwd=*** ',DbName) as COn c.courseid = a.id where A.subjectid = B.subjectid and C.cours

ExampleEXEC sp_addlinkedserver ' connection name ', ' ', ' SQLOLEDB ', ' Server hostname or IP '--Create a linked serverEXEC sp_addlinkedsrvlogin ' connection name ', ' false ', NULL, ' database user name ', ' Database connection password 'Exec sp_droplinkedsrvlogin Connection Name, Null--delete mapping (map to remote login on linked server)Exec sp_dropserver Connection Name--Remove remote server link--query ExampleSELECT * from connection name. Database name. dbo. SurfaceSQL Server query across

Tags: standard database dump Zip class false redirect www.Original: http://www.open-open.com/code/view/1420121471484This method can be used to back up the local database to the remote host via mysqldump, and the transfer of intermediate data is encrypted via SSH. The standard input is read by cat on the remote host and the mysqldump is redirected to the file.Mysqldump Mysqldump backing up databases to offsite servers

name)--Raw cost surface select * into table from OPENROWSET (' SQLOLEDB ', ' SQL Server name '; ' User name '; ' Password ', database name. dbo. Table name--Import the local table into the remote table Insert OPENROWSET (' SQLOLEDB ', ' SQL Server name '); ' User name '; ' Password ', database name. dbo. Table name) Select *from Local table--Update local table updated B set B. Column a=a. Column A from OPENROWSET (' SQLOLEDB ', ' SQL Server name '; ' User name '; ' Password ', database name. db

1. Cheap (heard not to spend money)2. Stability (1. No poisoning 2. Can run for several days continuously)3. Open source (source is open)Because the graphical page does not use the OS such as Windows and so on, so very few people use it, support Linux application software is also relatively small.Because we are learning to develop, we will meet to deploy the code to the Linux server, so we still need to learn some common Linux operations.Why servers a

the Parade accelerator (Small ads: Available Thunderbolt online accelerator replacement, landlord has been in use, feel good. ）， In the multi-play League of Legends Box installation directory has a xunyou folder, directly deleted; Then in the C:\Windows directory search xunyount file, delete it; Now run cmd as Administrator, type netsh winsock reset and enter (note that it must be run as administrator, this resets the LSP connection because the cruise speed modifies t

Label: USE [master] GO -- Method 1: I use this method EXECsp_attach_single_file_db @dbname=‘TestDb‘, @physname=N‘C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\TestDb.mdf‘ GO -- Method 2: CREATEDATABASETestDbON (FILENAME = N‘C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\TestDb.mdf‘) FORATTACH_REBUILD_LOG GO Statement 1 is to attach the file to the database, and if something like this happens to me. Therefore, the executi

Certs folder. The root certificate file extension begins with a numbered sequence similar to. 0 and. 1. The CRL file extension begins with a sequence similar to. r0 or. R1. The CRL file is associated with the certificate.Change the root certificate's extension to. crt. When asked if you are sure you want to change the extension, click Yes or OK. Otherwise, the expected functionality of the file is changed. The file icon changes to the icon that represents the root certificateRight-click the roo

unblocked.To install SNMP in Client 152:Yum-y Install NET-SNMP net-snmp-utils#更改配置文件以下信息: Line 41st, line 62nd, line 85thVi/etc/snmp/snmpd.conf#com2sec notconfiguser default publiccom2sec notconfiguser 192.168.1.151 public#access Notconfiggroup "" any noauth exact systemview none noneaccess notconfiggroup "" Noauth exact all none none# will #view all included. 1 80 The previous # comment removes the view all included . 1 80Finally, start or restart t

"Advantages" powerful, operation-like SCP, support to exclude directories, support speed limit parameters, also support local replication."Disadvantage" noUsageRsync is a data-mirroring Backup tool under Unix-like systems, and--remote sync can be seen from the name of the software. It operates in the same way as the SCP and is much more powerful than the SCP. When using a double colon to split the hostname and file path, the rsync server is used, which is not described here.Command format:rsync

Expiration Time: The time stamp indicates how long the password is valid, expire immediately after expiration, regardless of the password expiration dateTimestamp conversion formula: date-d "1970-01-01 16066 Days"/etc/groupGroup name: group Password flag: GID: Additional user in Group/etc/gshadowGroup name: Group Password: Group Administrator user name: additional users in GroupHome DirectoryNormal User:/home/user name/, owner and owning group are this user, permissions 700Superuser:/root/, own

command chattr the root directory of the FTP service to make additional permissions to modify Chattr + A + directory name (home or home under the user name to name the directory), after the permissions are modified to use the command lsattr–d + directory name to view permissions At this point, you can again through the client to log on to the FTP server, there is no permission to delete the FTP server files, have unique permissions must be the root userBo Master original articles, reproduc