Đang chuẩn bị liên kết để tải về tài liệu:
MASTERING SQL SERVER 2000- P8

Tham khảo tài liệu 'mastering sql server 2000- p8', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | 320 I CHAPTER 9 USING SQL SERVER ENTERPRISE MANAGER New maintenance plan Maintenance plan history Backup database Restore database Truncate log Shrink database Modify data file sizes Modify log file sizes The Table Info page of the taskpad lists all of the tables and indexes within the database. For each table this page also shows the number of rows of data that the table currently contains. A bar graph shows you the amount of space occupied by each table and index. The Wizards page of the taskpad offers another way to invoke any of the SQL Server Wizards. From any database node you can perform common database tasks by using the shortcut menu. These include Create a new database Create new database objects Delete an existing database Import data Export data Create maintenance plan Generate SQL scripts Back up database Restore database Shrink database Detach database Copy subscription database View replication conflicts THE SQL SERVER ENTERPRISE MANAGER TREE 321 NOTE You ll learn more about databases in Chapter 10. Diagrams When you click a Diagrams node the right pane of SQL Server Enterprise Manager shows all of the database diagrams that have been created for the database. A single database might have no database diagrams a single database diagram or multiple database diagrams representing its structure. Double-clicking a database diagram will open it in the database diagram designer. From the Diagrams node you can create and delete database diagrams. You can create new database diagrams with the node s shortcut menu and you can delete database diagrams with the individual diagram s shortcut menu. This is typical of how all the objects in Enterprise Manager work. NOTE You ll learn more about database diagrams in Chapter 11. Tables When you click a Tables node the right pane of SQL Server Enterprise Manager shows all of the tables in the current database as you can see Figure 9.11. For each table SQL Server Enterprise Manager lists the table name the owner name .