Page 49 - DCAP508_DATABASE_ADMINISTRATION

Unit 3: SQL Server Tools

4. Discuss the various components of management studio. Notes
5. What is Log File viewer in SQL server? Also discuss its usage.
6. Analyze the statement: “You can open Log File Viewer in several ways, depending on the
information that you want to view.”

7. Explain how to open Log File Viewer:
(a) To view logs that are related to general SQL Server activity
(b) To view logs that are related to jobs
(c) To view logs that are related to maintenance plans
8. Describe how you will show the Registered Servers window in SQL server enterprise
manager.
Answers: Self Assessment

1. Object Explorer 2. document window
3. Management Studio 4. Servers
5. Object Explorer 6. Frequently
7. Database Engine 8. False

9. True 10. False

3.6 Further Readings

Books C.J. Date, Introduction to Database Systems, Pearson Education.
Elmasri Navrate, Fundamentals of Database Systems, Pearson Education.
Peter Rob & Carlos Coronel, Database Systems Design, Implementation and
Management, 7th Edition.
Raghurama Krishnan, Johannes Gehrke, Database Management Systems, Tata
McGraw Hill, 3rd Edition.
Silberschatz, Korth, Database System Concepts, McGraw Hill, 5th Edition.

Online links www.sql-tutorial.net/

www.w3schools.com/sql/
www.sqlservertutorials.com/

LOVELY PROFESSIONAL UNIVERSITY 43