tailieunhanh - Hướng dẫn học Microsoft SQL Server 2008 part 16

Các nút Security được sử dụng để quản lý bảo mật máy chủ toàn: ■ Đăng nhập: Server cấp chứng thực đăng nhập ■ Server Roles: vai trò an ninh được định nghĩa sẵn ■ Giây chứng nhận: Danh sách các nhà cung cấp các thông tin ■ Cryptographic: Được sử dụng cho việc mã hóa dữ liệu tiên tiến | Part I Laying the Foundation The Security node is used to manage server-wide security Logins Server-level authentication of logins Server Roles Predefined security roles Credentials Lists credentials Cryptographic Providers Used for advanced data encryption Audits Part of SQL Audit collects data from Extended Events Server Audit Specifications Defines a SQL Audit for a server-level audit The Server Objects node holds server-wide items Backup Devices Organizes tapes and files Endpoints HTTP endpoints used by database mirroring Service Broker SOAP and T-SQL Linked Servers Lists predefined server credentials for distributed queries Triggers Contains server-level DDL triggers The Replication node is used to set up and monitor replication Local Publications Lists publications available from this server Local Subscriptions Lists subscriptions this server subscribes to from other servers The Management node contains several server-wide administration tools Policy Management SQL Server s new policy-based management Data Collection Define data collection points for SQL Server s Management Data Warehouse Resource Governor Control Enterprise Edition s CPU and Memory Resource Governor Maintenance Plans Create and manage maintenance plans SQL Server Logs SQL Server creates a new log with every restart. View them all here. Database Mail Configure and monitor Database Mail Distributed Transaction Coordinator Manage DTC for transactions involving multiple servers Legacy Contains deprecated objects such as DTS packages and older database maintenance plans The final node links to SQL Server Agent tools if SQL Server Agent is running Jobs Control SQL Server Agent jobs Job Activity Monitor View job activity Alerts Configure SQL Server Agent alerts Operators Set up SQL Server Agent operators Proxies Manage SQL Server Agent externally Error Logs View SQL Server Error Logs 112 Using Management Studio 6 Because Management Studio and SQL Server are communicating as .