Database Administration Basics

You perform most database administration work through SQL Server Management Studio. Use SQL Server Management Studio to carry out many common database administration tasks, including:

  • Viewing database information

  • Checking user and system databases

  • Examining database objects

This section examines each of these tasks.

Viewing Database Information in SQL Server Management Studio

SQL Server organizes information using a top-down hierarchy that starts with server groups at the highest level and then moves down to servers, and then to databases, and then to objects. Therefore, you must work your way down to the database level to view the databases installed on a particular server instance. If you have registered a server instance ...

Get Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.