The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P20: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | Installing SQL Server 2008 Chapter 2 77 Database Instances Files Locations Filegroups and Performance 0 A SQL Server database instance is a collection of user and system databases with a copy of the SQL Server binaries. 0 Datafiles contain data and database objects such as tables and indexes. Logfiles contain the transaction log for recovering the database. 0 Filegroups are structures by which administrators logically organize data files to optimize performance. 78 Chapter 2 Installing SQL Server 2008 Exam Objectives Frequently Asked Questions Q How much time should I invest in planning for the SQL Server 2008 upgrade A The answer is how much time and money can you afford if the upgrade is not successful Careful planning and testing not only guarantees a successful upgrade but it is also an opportunity for you and your team to become experienced in the various SQL Server 2008 products and features before going to production. Q How should I prepare for the upgrade process A First run the SQL Server 2008 Upgrade Advisor to identify any issues and provide guidance on resolving any problems. Rehearsing the upgrade process on a test environment repeatedly for several weeks prior to the upgrade will provide confidence in the basic procedures. The testing of the backup and recovery scenarios is an opportunity to train less experienced individuals. Training and building a team benefit the upgrade investment. Q What business requirements should drive the upgrade process A The customer s budget and sensitivity to application database outage are the key drivers to the upgrade process. The amount of downtime will steer the selection process toward upgrading a database instance or performing a side-by-side install. Q What are the key requirements selecting the SQL Server version A The business usage and requirements of the database application s scalability availability and security in coordination with the hardware constraints are essential in the determining the SQL Server .
