Technology of SQL Server database (37)
Tuesday, March 03, 2009 by rain
The database is safeguarded can make the database maintains move in groove.Found a database to safeguard a plan to be able to let SQL Server maintain a database automatically effectively,Save many time for the administrator,Also can prevent database of incur loss through delay defend the work.The procedure that establishs a database to defend a plan is as follows:
(1) the database that defends a plan should be founded in the choice in Enterprise Manager,Click right key,Choose from inside quick menu " all tasks (All Tasks) " child in menu " Maintenance Plan (defend a plan) " dish is individual,The greeting interface that if place of graph 6-14 is shown,appears.
(2) click " next " pushbutton,The choice database dialog box that if place of graph 6-15 is shown,appears.The database that can maintain according to needing to choose to want.
(3) click " next " pushbutton,The dialog box of information of newer data optimization that if place of graph 6-16 is shown,appears.The data page that whether can want pair of databases according to needing to choose or index page do heavy full employment.Click " Change " pushbutton,The editor loop job that if place of graph 6-13 is shown,appears plans a dialog box.
(4) click in graph 6-16 " next " pushbutton,The database integrality that if place of graph 6-17 is shown,appears checks a dialog box.Can choose to whether want to do integrality to check to the database,Is wrong.
(5) click " next " pushbutton,If place of graph 6-18 is shown,appear appoint database backup to plan a dialog box.Can choose to whether back up the database tape or hard disk.Choose to back up the database commonly hard disk.
(6) click " next " pushbutton,Appear to appoint a database to back up the file deposits catalog dialog box like what place of graph 6-19 shows.Can choose to back up the database the file deposits designation hard disk catalog,Still can found a subdirectory to every database.
(7) click " next " pushbutton,Appear to appoint clerical log file backup to plan a dialog box like what place of graph 6-20 shows.In can choosing to whether join clerical log backup the database to defend a plan.
(8) click " next " pushbutton,Appear to appoint clerical log file backup to deposit catalog dialog box like what place of graph 6-21 shows.The relevant option that can choose to whether deposit clerical log backup.
(9) the generation that clicks next pushbutton to if place of graph 6-22 is shown,appear safeguards what plan report dialog box can choose to report to deposit the option such as catalog
(10) click " next " pushbutton,The designation that if place of graph 6-23 is shown,appears safeguards a plan to carry out historical record to deposit positional dialog box.Can choose to deposit its go up in this locality server or long-range server.
(11) click " next " pushbutton,The final interface that if place of graph 6-24 is shown,appears,Appoint safeguard plan name dialog box.After inputting a name,Click " finish " pushbutton,Finish the setting that defends a plan.
Good in the setting after defending a plan,Can examine in Enterprise Manager, revise it.In business management implement in below server folder " Management " choose below subdirectory " Database Maintenance Plans " the plan that can see a setting.Place of the 6-25 that be like a graph is shown.
The database that in window of graph 6-25 the choice should revise defends plan title,Click right key,Choose from inside quick menu " attribute (Properties) " option,The database that if place of graph 6-26 is shown,appears safeguards a plan to edit a dialog box.The almost all information that can compile to be installed in the place in planning to generate guide.