Maintenance wizard is which of the following




















Clicking the Next button will allow you to continue with the creation of the database maintenance plan. The Next button will open the following screen:. The first option in this dialog will instruct the plan to reorganize the data and index pages in the database. If this option is selected, the statistics are recreated automatically when this step runs.

Updating the statistics will increase the performance and reliability of the database s in question. If you select the option to reorganize then you cannot select the update statistics box because the statistics will automatically get recreated. You can however, just select the update statistics box without the reorganization.

You can also specify that you would like to remove unused space from the database files. During the course of normal operations, database files will become filled with unused space, which will lead to decreased performance. After these options are selected, click the Next button to continue with the wizard and the following screen is shown:. The integrity check can be configured to include indexes and attempt to repair any problems that it finds.

The checks can also be setup to be performed before doing a backup. This option can have negative side effects either way. The integrity check may take up precious time on the server, but it can fix problems. On the other hand, the check may not be able to fix all the problems that it encounters. The check can also be scheduled by clicking the Change button to set up the schedule.

This screen allows the creation and schedule of the backup and to specify the location of the backup file, as well as, to verify the integrity of the backup when the operation is complete. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Security Permissions To create or manage Maintenance Plans, you must be a member of the sysadmin fixed server role.

Click the plus sign to expand the Management folder. To create a maintenance plan using the design surface In Object Explorer, click the plus sign to expand the server where you want to create a maintenance plan.

Maintenance plan tasks can be scheduled in order to run periodically or can be left without a schedule and run manually when needed. Note, that it is possible to choose one schedule for all maintenance tasks included in the plan as well as a separate schedule for each of them. You can set the schedule by clicking the "Change" button:. On the page above, there are various options for configuring the schedule.

After scheduling and clicking "Next" we will see core database maintenance tasks. As we can see, there are 11 tasks and it is possible to include more than one task in a plan. It is an important task in terms of making sure that the database is consistent and is not damaged. We will continue by clicking "Next":. As there is only one task, the buttons for arranging task order is not active. After clicking "Next" again, the screen for choosing databases will appear:.

Hence, it is possible to set the task for all databases, only for the system databases or for specific databases. Additionally, it is there is a checkbox for ignoring databases that are not online.

That brings up the following screen:. Figure 7. This begins the integrity checks portion of the plan. While you might think that you want to have the Maintenance Wizard automatically fix a problem, that's usually not a good idea. There are two reasons for this. Normally, "minor" problems turn into major ones. Also, the database has to be in single-user mode to use this choice. Figure 8. This panel allows me to select a database backup.

A word here about backup software. This saves me a ton of money on backup software, and provides three levels of protection. Besides the running backup, I normally have 1 the files on a RAID system, 2 the backup file on the hard drive, and 3 the tape of the "dead" files off-site. If I ever need to restore the backup, I can select the last one from the drive rather than calling my offsite vendor to get back the latest tape.

Of course, if you have a central backup strategy, or limited drive space, by all means use the external software. Figure 9. There are three interesting choices here. The first choice allows me to change the directory where I store the database backup files. The second choice creates a subdirectory for each database — an especially handy choice for multiple databases in the plan.

The last choice is to remove backup files older than a certain number of days. I use this option for as many days as the space on the drive can afford, for all the reasons I mentioned earlier. Figure However, this option only works if the database is in the Full or Bulk Logged recovery mode. This panel gives me the feedback I need.

You can also have the results e-mailed to you, if SQL Mail is set up properly. For the cleanup step, I also have the plan remove the reports on the same level as the old backups. I select Next to continue. This panel continues the reporting, by placing the results of the plan in a table. If you have a central server used for reporting, you can send the results there with an option on this tab as well. Here I name the plan. I can even add steps to that job and make a more customized plan for the server.

Once the plan runs, I can open the Query Analyzer tool, set the output to text, and run the following script:. I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.

Pearson Education, Inc. This privacy notice provides an overview of our commitment to privacy and describes how we collect, protect, use and share personal information collected through this site. Please note that other Pearson websites and online products and services have their own separate privacy policies.

To conduct business and deliver products and services, Pearson collects and uses personal information in several ways in connection with this site, including:.

For inquiries and questions, we collect the inquiry or question, together with name, contact details email address, phone number and mailing address and any other additional information voluntarily submitted to us through a Contact Us form or an email. We use this information to address the inquiry and respond to the question. We use this information to complete transactions, fulfill orders, communicate with individuals placing orders or visiting the online store, and for related purposes.

Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. Participation is voluntary. Pearson collects information requested in the survey questions and uses the information to evaluate, support, maintain and improve products, services or sites, develop new products and services, conduct educational research and for other purposes specified in the survey.



0コメント

  • 1000 / 1000