Sample chapter from "MCSE Microsoft® SQL Server™ 2000 Administration Readiness Review; Exam 70-228". The Managing, Monitoring, and Troubleshooting SQL Server 2000 Databases domain examines the tasks administrators will face on a day-to-day basis. These tasks include:
Creating a database and ensuring that the database performs well
When creating a database, administrators must take into consideration certain SQL Server configuration settings, such as database and log file location. These settings will ultimately affect the performance of the database.