Microsoft 70-431 Exam Chapter Summary

"Microsoft SQL Server 2005 Implementation & Maintenance", also known as 70-431 exam, is a Microsoft certification.

SQL Server 2005 includes five editions, with each edition having different func-tionality and feature sets and different infrastructure requirements. Understand-ing the editions and their hardware, OS, and network requirements is key to selecting the correct edition for your needs.

You can install a default, unnamed instance of SQL Server 2005 and multiple additional named instances on the same server. Multiple instances can be bene-ficial for testing purposes and for separating different customers’ databases.SQL Server 2005 requires at least one account for use by the SQL Server serviceand the SQL Server Agent service. To make sure that the SQL Server service doesn’t have more privileges than necessary, you often need to use a separate account for each service.

When upgrading a SQL Server installation to SQL Server 2005, you can perform either an in-place upgrade or a side-by-side migration. A side-by-side migration,
which allows for the continuous operation of the original database environment while the upgraded environment is being installed and tested, can often mini-mize downtime for the SQL Server environment.

You can use detach/attach, backup/restore, the Copy Database Wizard, or man-ual scripting to move database files in a side-by-side migration. Whichever method you choose, you should make a copy of your original files in case you need to recover your original environment because of an upgrade problem.

More information:MB2-633 MB7-639 70-502(CSharp) 70-502(VB) 70-656