Detailed SQL Server "Database maintenance plan"

As a network administrator, regardless of the size of its management networks is large or small, in the day-to-day management in addition to maintaining the smooth operation of the network, timely removal of network failures, protection of network security and other work, backup network key data is a very important part of the work.

All kinds of faults in the network are divided into two types: software failure and hardware failure. For "Hardware failure" can be repaired or replaced by hardware equipment to be resolved in a timely manner; For software failure, it can be solved in time by reinstalling or upgrading software, redo the network or applying software system, and it is necessary to solve the network failure by using this method to recover the normal and essential data support. However, the vast majority of the damage or loss of critical data such as the network, especially in the application software system, cannot be recovered or compensated for. Even if some of the data can be recovered, the costs (such as time, human, financial, material, and so on) are likely to go far beyond the company's affordability.

Therefore, the focus on data backup work is the day-to-day management of the network administrator must always pay attention to a task, but also must periodically repeat the operation of a work.

Current backup strategy

My company in the formation of local area network, taking into account the characteristics of commercial enterprises, carefully consider the purchase, sale, storage of the three major links occurred in various data and store problems, selected by Windows Server as the operating system, SQL Server 2000 for the database platform to build the LAN application system software platform, the network cable as the carrier will buy, sell, storage and other core departments of the computer through the LAN platform tightly connected. In this way, any business in each of the core departments is stored in a timely and dynamic manner in the SQL Server 2000 database on the core Dell server of the corporate LAN, providing the various data services required by the parties on the basis of this platform.

Therefore, since the company's local area network began to operate on the day, as a network administrator I am very focused on the local area network key data-especially these business data backup work. At the same time, I also want the software that backs up the data to achieve the following automatic functions.