tailieunhanh - Beginning SQL Server 2005 for Developers From Novice to Professional phần 6

6. Nhấp vào nút OK ở dưới cùng của màn hình để tạo ra các cơ sở dữ liệu. SQL Server sẽ thực hiện một vài hành động. Đầu tiên, nó kiểm tra xem cơ sở dữ liệu đã tồn tại, và nếu như vậy, bạn sẽ phải chọn một tên khác. Một khi các cơ sở dữ liệu | 242 CHAPTER 7 DATABASE BACKUPS RECOVERY AND MAINTENANCE 16. Similar to when we produced a script for the database clicking next brings up a summary of what will be performed within the plan see Figure 7-37 . Here you can review what will be completed and with the number of different options that will be performed it is a good place to complete a double check. Clicking Finish will produce the maintenance plan itself. Figure 7-37. Completing the plan 17. It is possible to execute the plan outside of the maintenance plan schedule. The maintenance plan created previously can now be found under the Management Maintenance Plan nodes in the Object Explorer. Right-click the nodes to bring up the pop-up menu shown in Figure 7-38. Selecting Execute will start the plan immediately. Do so now. Figure 7-38. Maintenance plan pop-up menu 18. While the plan is executing the dialog box shown in Figure 7-39 will be displayed. 19. Once the plan is executed along with any additional plans a log is kept to allow you to check how they progressed. In Figure 7-40 you see that there is a circle with a cross in it which should appear red on your screen denoting that the plan had an error. By clicking that particular plan it is possible to see what the error was. CHAPTER 7 DATABASE BACKUPS RECOVERY AND MAINTENANCE 243 Figure 7-39. Maintenance plan executing Figure 7-40. Maintenance plan log Summary You have seen a great deal in this chapter that is crucial to ensuring that your database is always secure if there are any unforeseen problems. As a manager drummed into me the unexpected will always happen but you must always be able to recover from it no matter what. Therefore regular backups that are known to work and even the occasional disaster recovery test should be done to ensure that you can restore when something unexpected happens. No matter what your managing director says it is the data of a company that is its most important asset not the people. Without the data a company cannot .