TAILIEUCHUNG - Lesson Administering and Troubleshooting SQL Server 2000: Part 2D

In these lab exercises, students will be performing backup operations by creating a backup device. In addition, students will also be creating, managing, and troubleshooting SQL Server agents and jobs. | rni __ - Lesson 2D Experiment Administering and Troubleshooting SQL Server 2000 N JT Instructor Notes In these lab exercises students will be performing backup operations by creating a backup device. In addition students will also be creating managing and troubleshooting SQL Server agents and jobs. Exercise 1 The System Administrator of Scott Online Departmental store wants to monitor scheduled backup operations and their results for all the user databases. The System Administrator wants to assign this task to Allen and designate him as an SQL Server 2000 Operator. To designate Allen as an Operator the System Administrator wants to configure the operator options in SQL Server 2000. The System Administrator wants the notification of result of backup operations should be done through e-mail and NET SEND utility of Windows operating system. The e-mail and NET SEND addresses of Allen are allen@ and Allen respectively. In case of failure on notifying the message to the Operator the System Administrator wants to notify the results of backup operations to another operator James who is designated as a failsafe operator by SQL Server 2000. 1. Select Start- All Programs- Microsoft SQL Server- Enterprise Manager to open the Enterprise Manager console. 2. In the Console Root expand Microsoft SQL Server - SQL Server group - Default instance- Management- SQL Server Agent. 3. Right-click the Operators and then click the New Operator to open the New Operator Properties dialog box. 4. Type Allen in the Name text box. 5. Type allen@ in the E-mail text box. 6. Type Allen in the Net send address text box. 7. Select the Alert option from the Notifications screen. Select Backup as the Alert Name and select E-mail and Net Send as the notification media. 8. Click the OK button to close the New Operator Properties dialog box. NUT Administering and Troubleshooting SQL Server 2000 9. In the Console Root right-click SQL Server Agent and select the .

• Cơ sở dữ liệu
• SQL Server 2000
• Troubleshooting SQL Server 2000 part 2D
• Troubleshooting SQL Server 2000
• Lesson Administering and Troubleshooting SQL Server 2000
• Additional lab exercises
• Administering and Troubleshooting SQL Server 2000
• Tự học Microsoft SQL Server 2000
• Học Microsoft SQL Server 2000 trong 21 ngày
• Cơ sở dữ liệu quan hệ
• Cài đặt SQL Server 2000
• Nâng cấp SQL Server 2000
• Tiện ích của SQL Server 2000 Management
• Cơ sở dữ liệu
• Giáo trình SQL Server 2000
• cơ sở dữ liệu SQL Server 2000
• Dịch vụ SQL Server 2000
• Tạo cơ sở dữ liệu
• sử dụng SQL server 2000
• hướng dẫn sử dụng SQL server 2000
• tài liệu sử dụng SQL server 2000
• cẩm nang sử dụng SQL server 2000
• Bảng ảo
• Biến cục bộ
• hàm chuyển đổi kiểu dữ liệu
• Các hàm ngày giờ
• Các hàm toán học
• Các toán tử
• truy vấn dữ liệu
• Cấu trúc điều khiển
• biến kiểu dữ liệu Cursor
• Giá trị mặc định
• Giao tác