small business offsite backup

' backup database pubs to disk = @filePath + ' Pubs.bak ' Set @Sql = ' C:\progra~1\winrar\rar a-df-ep ' + @Filepath + ' + @Filepath + ' \*.* ' Exec xp_cmdshell @Sql, No_output Set @Sql = ' rd/s/q ' + @Filepath Exec XP_cmdshell @Sql Exec xp_cmdshell net use Y: \\192.168.1.3\backup 12345/user:192.168.1.3\dbbak ' exec xp_cmdshell ' move /y D:\dbbak\*.rar y:\ ' Exec xp_cmdshell ' Net use Z:/delete ' II, put t

The company has three SQL Server databases, every day through SQL Server scheduled tasks to back up data locally, and then by the local upload to the data server to do the save, so repeatedly, sometimes because of busy work, forget to upload, resulting in data is replaced without backup phenomenon.After learning about Linux, it's all just a small problem, and it doesn't need to be so troublesome to do it.

Before the article begins, ask the webmaster a question: What is important to the webmaster? In fact, for the webmaster, a lot of things are very important. But we are now excluding external factors, to narrow the scope of the web system itself, which is very important? The website data is one of them.The website data includes the program file itself, the attachment data (Pictures, documents, videos, etc.) and database files which are constantly generated during the operation of the website, and

connection resources are exhausted on your PC. Also, you can share an external hard disk between multiple PCs and store it in a secure place as a backup medium. 2.5-inch or 3.5-inch hard drive: The latest plug-and-play portable hard drives are mostly based on 2.5-inch hard drives and provide enough capacity to accommodate a certain size digital library. However, if you want to get an oversized drive, you need to use a 3.5-inch hard drive. For most p

indispensable.7). Most portal front-end pages are already static or cache, because the dynamic part of the visit will not be particularly much9. SVN contains code and configuration(1), SVN storage program code (without resources, large company basic resources and procedures are separated)(2), the configuration file for all services (lamp environment, such as: Apache httpd.conf configuration file)(3), development Team test environment using the configuration file(4), Office test ring use configu

operate, better control. In order to save costs, I did not separate the mysql-proxy out as a standalone server, because in that case, it will have to consider a single point of the problem. In this architecture, there is actually a flaw, that is, the NFS server is also risky, more insurance is to engage in a separate servers to do NFS services.7. Continue to expandUV up to 100w, two WEB servers are obviously not enough, and the bottleneck is not on MySQL. So, just add the WEB, pick up the NFS s

Environment: Windows Server 2003 Oracle 10g, Inter-system backupThe target system creates the shared file, and the original system mounts the shared directoryWrite batch script, call with scheduled taskRem*Because the system real-time requirements are not very high, the amount of data is small, and only one disk, consider offsite backup*Rem*

Trainer small project (5) security guard _ using content providers for text message backup correction version, trainer providers The text message backup class is basically finished in the last section. Iterative code development is required. Code reconstruction and decoupling are required after the development. Knowledge points that can be learned ① Application