|
|
This is only a preview of the paper
Click here to register and get the full text.
Existing members click here to login
|
|
|
The role of a DBA in a global society
A database administrator is the individual responsible for maintaining the RDBMS system.
The DBA role naturally divides into three major activities: ongoing maintenance of production databases (operations DBA); planning, design, and development of new database applications, or major changes to existing applications (development DBA, or architect); and management of an organisations data and metadata (data administrator). One person may perform all three roles, but each is profoundly different. ...
Monitoring the Database Servers Health and Tuning Accordingly
Monitoring the health of the database server means making sure that the following is done:
„X The server is running with optimal performance.
„X The error log or event log is monitored for database errors.
„X Databases have routine maintenance performed on them, and the overall system has periodic maintenance performed by the system administrator.
Using Storage Properly
SQL Server 2000 enables you to automatically grow the size of your databases and transaction logs, or you can choose to select a fixed size for the database and transaction log. ...
Performing Backup and Recovery Duties
Backup and recovery are the DBAs most critical tasks; they include the following aspects:
„X Establishing standards and schedules for database backups
„X Developing recovery procedures for each database
„X Making sure that the backup schedules meet the recovery requirements
Managing Database Users and Security
With SQL Server 2000, the DBA works tightly with the Windows NT administrator to add user NT logins to the database.
Approximate Word count = 978
Approximate Pages = 3.9
(250 words per page double spaced)
|
|
|
|
|
|