Chapter 3

Designing a Consolidation Strategy

MICROSOFT EXAM OBJECTIVES COVERED IN THIS CHAPTER:

  • Design a database consolidation strategy.
    • Gather information to analyze the dispersed environment.
    • Identify potential consolidation problems.
    • Create a specification to consolidate SQL Server databases.
    • Design a database migration plan for the consolidated environment.
    • Test existing applications against the consolidated environment.

images SQL Server 2005 is a powerful platform capable of handling many different applications at once. However, in most cases, each application will have its own dedicated SQL Server that is underutilized. This results in greater ...

Get MCITP Administrator: Microsoft® SQL Server™ 2005 Database Server Infrastructure Design Study Guide 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.

Start your free trial