fortnight server maintenance

The core position of servers in applications, I believe that friends who can visit server channels should have a thorough understanding of them. How much do you know about server maintenance? Here, I will show you some things I know. First, I hope to give you a basic reference, and second, I hope it will arouse your awareness of

Using a maintenance plan for SQL Server 2008 enables you to automatically back up the database and automatically remove the functionality of outdated backups.First, the environmentOs:microsoft Windows Server 2003 R2Soft:microsoft SQL Server 2008Backing up the database path C:\sql_bakSecond, the configurationLogin Micro

Server Security Maintenance Tips 1: Start from basics When we talk about network server security, the best advice I can give you is not to be a layman. When a hacker starts to launch an attack on your network, the hacker first checks whether there are common security vulnerabilities before considering more difficult means to break through the security system. The

Tags: statistics autostats auto_update_statisticsSelection of SQL Server statistics Maintenance policyProblem Description:After archiving a tens of millions of tables in an OLTP system, the business application receives a timeout alert when the source table data is deleted in batches, as follows:V1.1.1.1: ****process-querytransactionfor****: 23075129 Timeout expired.The timeout period elapsed prior to compl

This article turns from http://543925535.blog.51cto.com/639838/1427529In the daily SQL maintenance, there are many tasks that need to be repeated periodically, we are not likely to do manual operations, such as backup jobs, rebuild maintenance index, database collation and so on.Take backup as an example, we usually put the time period of database backup at night, then we can make the backup job repeat peri

Hardware maintenance Hardware maintenance is equally important to software. Readers must have a clear understanding of the hardware system of the server and the entire network environment. However, it is simple and easy to say. hardware maintenance is nothing more than adding and detaching equipment, replacing equipmen

SQL Server maintenance plan for database backup (step by Step)First, PrefaceSQL Server Backup and restore all -in-a-kind, including the use of SSMS operation to restore a variety of backup files graphical guidance,SQL Server Database Minimum outage migration scenario , which uses SQL script (T) to complete a full backu

http://jxtm.jzu.cn/?p=3692Hello everyone, I am a South African ant, today share with you the topic is: Online linux server operation and maintenance security policy experience. Security is the IT industry a commonplace topic, from the previous "prism door" incident reflected a lot of security issues, to deal with information security issues have become urgent. Therefore, as operations personnel, it is neces

update the statistics,For a 5000W row table, you can specify that the changes exceed 60W rows (customized according to business conditions), and manually update the statisticsAt the same time, depending on the table, on the relatively small table, specify a relatively high percentage of samples, on a relatively large table, specify a relatively low sampling percentageFor example, for 1000W rows of the table, the time to update the statistics of the sampling percentage position 60%, for the 5000

As the name implies, the United States server hosting is the enterprise host to the United States IDC service provider to improve the room environment, the use of service providers to provide a constant environment, IP, bandwidth and other network resources, and a part of the daily management work entrusted to the service providers. Enterprises have a certain autonomy to meet their own space requirements. So how do enterprises and service providers th

 SQL Server Maintenance Plan Maintenance Plan is a very useful maintenance tool that can accomplish most of the database maintenance tasks, and by encapsulating these features, you can save a lot of code writing time. There is not a lot of information on the network.Databa

Server maintenance knowledge 1. boot sequence Generally, the system should strictly follow the steps below: Turn on the total power supply. Power on the computer Cabinet Power on external devices (such as disk arrays and tape libraries) After the external device self-check is complete, the host is powered on. Server maintenan