1 SQL Server 2005 DBA Microsoft SQL Server SQL ServerSQL Server SQL Server SQL Server SQL Server SQL Server 2005 SQL Server 2005 SQL Server 2005 o o o SQL Server 2005 1 SQL Server 2005... 3 2 SQL Server 2005... 9 3 SQL Server 2005... 17 4 SQL Server 2005... 21 5SQL Server 2005... 35 Microsoft SQL Server 2005
1 SQL Server 2005 SQL Server 2005 2 Microsoft Windows Server 2003NTFS NTFS SQL Server 2000 Randy Dyess DBA SQL Server SQL Server DBA SQL Server SQL Server SQL Server SQL Server
1 SQL Server 2005 1 SQL Server 2005 SQL Server 2005 SQL Server 2005SQL Server SQL Server SQL Server 15 SQL Server 2005 SQL Server 2005 SQL Server 2005 32 64 SQL Server 2005 Enterprise Edition 32 64Enterprise EditionOLTP DBAEnterprise Edition SQL Server 2005 Standard Edition 32 64Standard Edition Enterprise Edition Standard Edition SQL Server 2005 Workgroup Edition 32Workgroup Edition DBA Workgroup Edition Microsoft SQL Server 2005
1 SQL Server 2005 SQL Server 2005 Developer Edition 32 64Developer Edition SQL Server 2005 Enterprise Edition Developer Edition Enterprise Edition Enterprise Edition SQL Server 2005 Express Edition 32SQL Server Express Express Edition Express EditionExpress Edition Microsoft Access SQL Server 2005 SQL Server 2005 1-1 SQL Server 2005 Express Workgroup Standard Enterprise CPU 1 2 4 1 GB 3 GB 64 Windows on WOW Windows (WOW) 4 GB 1-1 SQL Server 2005 Developer Edition Enterprise Edition
1 SQL Server 2005 Express Workgroup Standard Enterprise Management Studio Database Tuning Advisor SQL Best Practices Analyzer Notification Services Service Broker 25 5 Oracle Oracle 1-1 SQL Server 2005 Developer Edition Enterprise Edition Microsoft SQL Server 2005
1 SQL Server 2005 Express Workgroup Standard Enterprise Web HTTP BI Development Studio Web Reporting Reporting Services Services Analysis Services 1-1 SQL Server 2005 Developer Edition Enterprise Edition Quick Check 1. SQL Server 2005 2. SQL Server 2005 SQL Server 2005 Enterprise Edition Developer Edition Standard Edition Workgroup Edition Express Edition Quick Check 1. Express Edition 2. Enterprise Edition Oracle Developer Edition
1 SQL Server 2005 Enterprise Edition Developer Edition Standard Edition Workgroup Edition Express Edition 1. SQL Server 2005 CPU CPUSQL Server 2005 A. SQL Server Express Edition B. SQL Server Workgroup Edition C. SQL Server Developer Edition D. SQL Server Standard Edition 2. SQL Server 2005 A. SQL Server Express Edition B. SQL Server Workgroup Edition C. SQL Server Enterprise Edition D. SQL Server Standard Edition Microsoft SQL Server 2005
1 SQL Server 2005 3. SQL ServerSQL Server 2005 A. SQL Server Express Edition B. SQL Server Workgroup Edition C. SQL Server Developer Edition D. SQL Server Standard Edition NOTE
2 SQL Server 2005 2 SQL Server 2005 SQL Server 2005 Windows OS 25 OS SQL Server 2005 Windows OSSQL Server 2005 32 64 SQL Server 2005 SQL Server 2005 SQL Server 2005 32 64 SQL Server 2005 32 SQL Server 2005 32 Pentium III 600-MHz 1-GHz SQL Server 2005 DBA Microsoft SQL Server 2005
1 SQL Server 2005 OS SQL Server 2005 Windows OS Service Pack 32 SQL Server 2005 OS SQL Server 2005 Enterprise Edition Windows Server 2003 Standard Edition Service Pack 1 SP1 Windows Server 2003 Enterprise Edition SP1 Windows Server 2003 Datacenter Edition SP1 Windows Small Business Server 2003 Standard Edition SP1 Windows Small Business Server 2003 Premium Edition SP1 Windows 2000 Server SP4 Windows 2000 Advanced Server SP4 Windows 2000 Datacenter Server SP4 SQL Server 2005 Standard Edition Windows Server 2003 Standard Edition SP1 Windows Server 2003 Enterprise Edition SP1 Windows Server 2003 Datacenter Edition SP1 Windows Small Business Server 2003 Standard Edition SP1 Windows Small Business Server 2003 Premium Edition SP1 Windows 2000 Server SP4 Windows 2000 Advanced Server SP4 Windows 2000 Datacenter Server SP4 10
2 SQL Server 2005 Windows 2000 Professional SP4 Windows XP Professional SP2 SQL Server 2005 Workgroup Edition Enterprise Standard OS Windows XP Media Edition SP2 Windows 2000 Professional SP4 SQL Server 2005 Express Edition Enterprise Standard OS Workgroup OS Windows XP Home Edition SP2 Windows Server 2003 Web Edition SP1 Developer Edition Enterprise Standard OS Workgroup OS Windows XP Home Edition SP2 OS SQL Server 2005 32 SQL Server 2005 SQL Server 2005 Enterprise Edition 512 MB 1 GB RAM SQL Server 2005 Standard Edition 512 MB 1 GB RAM SQL Server 2005 Workgroup Edition 512 MB 1 GB RAM3 GB SQL Server 2005 Express Edition 192 MB 512 MB RAM1 GB SQL Server 2005 Developer Edition 512 MB 1 GB RAM 350 MB 390 MB Microsoft SQL Server 2005 11
1 SQL Server 2005 1-232 SQL Server 2005 Internet Information Server (IIS) SQL Server 2005 Microsoft Internet Explorer 6.0 SP 1 Microsoft Management Console MMC HTML Help Internet Explorer Internet ExplorerInternet Explorer Connectivity Only Internet Explorer 4.01 SP2 XML IIS Reporting Services IIS 5.0 OS SQL Server 2005 SQL Server 2005TCP/IP 1-2 32 SQL Server 2005 SQL Server 2005 64 SQL Server 2005 32 64 64 IA641 GHzItanium X641 GHzAMD Opteron AMD Athlon 64 Intel EM64T Intel XeonEM64T Intel Pentium IV OS 32 SQL Server 200564 SQL Server 2005 Windows OS Service Pack 64 SQL Server 2005 OS 12
2 SQL Server 2005 SQL Server 2005 Enterprise Edition (IA64) Windows Server 2003 64-Bit Itanium Datacenter Edition SP1 Windows Server 2003 64-Bit Itanium Enterprise Edition SP1 SQL Server 2005 Standard Edition (IA64) Windows Server 2003 64-Bit Itanium Datacenter Edition SP1 Windows Server 2003 64-Bit Itanium Enterprise Edition SP1 SQL Server 2005 Developer Edition (IA64) Windows Server 2003 64-Bit Itanium Datacenter Edition SP1 Windows Server 2003 64-Bit Itanium Enterprise Edition SP1 SQL Server Enterprise Edition (X64) Windows Server 2003 64-Bit X64 Datacenter Edition SP1 Windows Server 2003 64-Bit X64 Enterprise Edition SP1 Windows Server 2003 64-Bit X64 Standard Edition SP1 SQL Server 2005 Standard Edition (X64) Windows Server 2003 64-Bit X64 Datacenter Edition SP1 Windows Server 2003 64-Bit X64 Enterprise Edition SP1 Windows Server 2003 64-Bit X64 Standard Edition SP1 Microsoft SQL Server 2005 13
1 SQL Server 2005 SQL Server 2005 Developer Edition (X64) Windows Server 2003 64-Bit X64 Datacenter Edition SP1 Windows Server 2003 64-Bit X64 Enterprise Edition SP1 Windows Server 2003 64-Bit X64 Standard Edition SP1 SQL Server 2005 Express Edition Windows XP X64 Professional 64 32 SQL Server 2005 64 SQL Server 2005 64 SQL Server 2005 512 MB 1 GB RAM 350 MB 390 MB 1-364 SQL Server 2005 14
2 SQL Server 2005 Internet Information Server (IIS) SQL Server 2005 Microsoft Internet Explorer 6.0 SP 1 MMC HTML Help Internet Explorer Internet Explorer Internet Explorer Connectivity Only Internet Explorer 4.01 SP2 Reporting Services IIS 5.0 XML IIS OS SQL Server 2005 SQL Server 2005TCP/IP 1-3 64 SQL Server 2005 Quick Check SQL Server 2005 CPU CPU SQL Server 2005 SQL Server 2005 32 64 SQL Server 2005 Windows OS SQL Server 2005 SQL Server 2005 SQL Server 2005 Quick Check Enterprise Developer CPU Developer Microsoft SQL Server 2005 15
1 SQL Server 2005 1. SQL Server 2005Windows 2000 Server service pack A. SP1 B. SP2 C. SP3 D. SP4 2. SQL Server 2005Windows 2003 Server service pack A. SP1 B. SP2 C. SP3 D. SP4 3. SQL Server 2005 512 MB A. SQL Server Express Edition B. SQL Server Workgroup Edition C. SQL Server Developer Edition D. SQL Server Standard Edition NOTE 16
3 SQL Server 2005 3 SQL Server 2005 SQL Server 2005 SQL Server 2005 SQL Server 2005 SQL Server DBA SQL Server DBA SQL Server SQL Server SQL Server 2005 15 SQL Server 2005 SQL Server 2005 Microsoft SQL Server Installation Wizard named instance Setup.exe Microsoft SQL Server Installation Wizard Default 1-1 Microsoft SQL Server 2005 17
1 SQL Server 2005 1-1 NOTE SQL Server SQL Server 2005 SQL Server 2005 SQL Server SQL Server Agent SQL Server 2005 SQL Server service pack SQL Server 18
3 SQL Server 2005 Quick Check 1. SQL Server 2. SQL Server SQL Server 2005 service pack SQL Server Quick Check 1. SQL Server 2. SQL Server 2005 Microsoft SQL Server 2005 19
1 SQL Server 2005 1. SQL Server DBA service pack SQL Server A. SQL Server B. service packs C. SQL Server D. service pack SQL Server 2. SQL Server A. 1 B. 2 C. 3 D. 4 NOTE 20
4 SQL Server 2005 4 SQL Server 2005 SQL Server 2005 collation SQL Server 2005 30 SQL Server 2005 SQL Server SQL Server Agent SQL Server 2005 SQL Server 2005 SQL Server SQL Server Agent domain SQL Server SQL Server Agent SQL Server SQL Server Agent SQL Server Agent SQL Server SQL Server SQL Server Agent Microsoft SQL Server 2005 21
1 SQL Server 2005 SQL Server AgentDBA SQL Server IMPORTANT SQL Server SQL Server Agent SQL Server SQL Server SQL Server Agent SQL Server SQL Server Agent Network Service account Users SQL Server SQL Server Agent local system account Windows OS SQL Server SQL Server Agent SQL Server 2005 SQL Server SQL Server Agent SQL Server WindowsSQL Server SQL Server Agent SQL Server 2005 22
4 SQL Server 2005 CAUTION SQL Server SQL Server Agent SQL Server 2005 authenticationwindows SQL Server 2005 Windows Windows OS SQL Server 2005 SQL Server 2005 Windows OS SQL Server 2005 SQL Server 2005 Windows Windows SQL Server SQL Server OS Windows OS Macintosh UNIX DBA sa SQL Server NOTE Windows SQL Server Windows Windows Microsoft SQL Server 2005 23
1 SQL Server 2005 SQL Server 2005SQL Server Unicode Unicode Unicode SQL Server 2005 Windows OS Windows OS code page Windows OS WindowsWindows SQL Server 2005 Windows Windows collation Microsoft SQL Server Installation Wizard Windows OS Windows Windows SQL Server 2005 SQL Server 2005 Windows SQL Server 2005 SQL Server 2005 Quick Check 1. 2. SQL Server SQL Server Agent Quick Check 1. SQL Server 2. SQL Server SQL Server Agent 24
4 SQL Server 2005 PRACTICE SQL Server 2005 SQL Server 2005 1. CD Setup Microsoft SQL Server Installation Wizard End User License Agreement I Accept The Licensing Terms And Conditions Next 2. Installing Prerequisites Next 3. Welcome To The Microsoft SQL Server Installation Wizard Next 4. System Configuration Checker 1-2 1-2 System Configuration Checker 5. Next Microsoft SQL Server 2005 25
1 SQL Server 2005 6. 1-3 1-3 7. Next 8. 1-4 26 1-4
4 SQL Server 2005 9. Advanced Documentation, Samples, And Sample Databases 10. Sample Databases1-5Entire Feature Will Be Installed On Local Hard Drive 1-5 11. Next Microsoft SQL Server 2005 27
1 SQL Server 2005 12. Installed Instances 1-6 1-6 13. OK 14. 1-7 28 1-7
4 SQL Server 2005 15. Next 16. Next 17. Use The Built-In System Account Local System1-8 1-8 18. SQL Server Agent 19. Next CAUTION Microsoft SQL Server 2005 29
1 SQL Server 2005 20. Mixed Mode (Windows Authentication And SQL Server Authentication) 1-9 1-9 21. sa ID 22. Next 30
4 SQL Server 2005 23. 1-10 1-10 24. Next 25. Automatically Send Error Reports Automatically Send Feature Usage Data 1-11 1-11 Microsoft SQL Server 2005 31
1 SQL Server 2005 26. Next 27. 1-12 1-12 28. Install 32
4 SQL Server 2005 29. 1-13 1-13 30. Next 31. Finish SQL Server 2005 SQL Server SQL Server Agent SQL Server 2005 SQL Server SQL Server Agent SQL Server 2005 SQL Server SQL Server Agent Microsoft SQL Server 2005 33
1 SQL Server 2005 SQL Server 2005 Windows Microsoft SQL Server Installation Wizard SQL Server 2005 1. SQL Server 2005 A. SQL Server Agent B. Log Reader Agent C. SQL Server D. Replication Agent 2. SQL Server Windows A. Kerebos B. Windows C. D. NOTE 34
5SQL Server 2005 5SQL Server 2005 SQL Server 2005 DBA DBA SQL Server 2005 NOTE SQL Server 6.5 SQL Server 6.5 SQL Server 2005 6.5 SQL Server 7.0 SQL Server 2000 SQL Server 2005 SQL Server 20 SQL Server 2005 Microsoft SQL Server 2005 35
1 SQL Server 2005 SQL Server 7.0 SQL Server 2000SQL Server 2005 SQL Server SQL Server DBA SQL Server SQL Server SQL Server Books Online SQL Server 7.0 SQL Server 2000 SQL Server 2005 SQL Server 2005 SQL Server 1-4 SQL ServerSQL Server 2000 32 64SQL Server 2005 32 64 36
5SQL Server 2005 SQL SQL SQL SQL SQL SQL Server Server Server Server Server Server 2000 2000 2005 2005 2005 32 1 64 32 1 64 64 IA64 X64 SQL Server 7.0 SQL Server 2000 32 SQL Server 2000 64 SQL Server 2005 32 SQL Server 2005 64 IA64 SQL Server 2005 64 X64 1-4 SQL Server SQL Server 2005 DBA SQL Server 2005 1 64 OS X64 WOW64SQL Server 32 64 OS IA64 WOW64 SQL Server 32 Microsoft SQL Server 2005 37
1 SQL Server 2005 SQL Server DBA/ / Copy Database Wizard/ DBA DBASQL Server SQL Server 2005SQL Server SAN SQL Server SAN SQL Server 2005 SQL Server SAN DBA 38
5SQL Server 2005 DBA SQL Server backup backup file SQL Server SQL Server database restore SQL Server Copy Database Wizard DBA SQL Server Copy Database Wizard DBA SQL Server 2000 SQL Server 2005 DBACopy Database Wizard Microsoft SQL Server 2005 39
1 SQL Server 2005 SQL Server DBA Transact-SQLData Transformation Services DTS SQL Server Integration Services SSIS BCP DBA DBA Quick Check GUI 40
5SQL Server 2005 DBA SQL Server DBCC CHECKDB Quick Check / / Copy Database Wizard Microsoft SQL Server 2005 41
1 SQL Server 2005 SQL Server master model msdb tempdb master master SQL Server SQL Server SQL Server Setup SQL Server 2005 SQL Server DBCC UPDATEUSAGE 42
5SQL Server 2005 SQL Server SQL Server 2005 2 SQL Server PRACTICE DBA / / Practice 1 SQL Server 2000SQL Server 2005 SQL Server 2000 SQL Server 2005 NOTE SQL Server 2000 SQL Server 2000 1. SQL Server 2000 Enterprise Manager 2. Databases 3. pubs PropertiesData Files 4. pubs 5. Transaction Log 6. pubs Cancel Pubs Properties 7. pubs All Tasks Detach Database OK 8. Windows Explorer Microsoft SQL Server 2005 43
1 SQL Server 2005 9. SQL Server 2005 10. SQL Server Management Studio SSMS Databases Attach 11. Add 12. OK OK 13. SQL Server 2000 SQL Server 2000 Enterprise Manager DatabasesAll Tasks Attach Database 14. Pubs.mdf OK OK Practice 2 SQL Server 2000SQL Server 2005 SQL Server 2000 SQL Server 2005 NOTE SQL Server 2000 SQL Server 2000 1. SQL Server 2000 Enterprise Manager 2. Databases 3. pubs All Tasks Backup Database 4. OK 5. OK 6. SSMS 7. 8. DatabasesRestore Database 44
5SQL Server 2005 9. To Database pubs 10. From Device 11. File Add 12. 13. OK OK 14. Restore 15. Options 16. Restore As.mdf.ndf 17..ldf 18. OK OK SQL Server SQL Server 2005 SQL Server 2005 SQL Server SQL Server 2005 SQL Server 2005 Microsoft SQL Server 2005 45
1 SQL Server 2005 DBASQL Server SQL Server 2005 / / Copy Database Wizard SQL Server SQL Server 1. A. SQL Server 2005SQL Server B. SQL Server 2005 C. SQL Server 2005 D. SQL Server 2005 2. A. Copy Database Wizard B. / C. D. 46
5SQL Server 2005 3. SQL Server A. B. C. D. NOTE Microsoft SQL Server 2005 47
1 SQL Server 2005 SQL Server 2005 OS SQL Server 2005 SQL Server 2005SQL Server SQL Server Agent SQL Server SQL Server SQL Server 2005 SQL Server / / Copy Database Wizard 48
1 authentication backup backup file code page collation database restore domain local system account Mixed Mode authentication named instance Network Service account Windows Windows collation SQL Server 2005 SQL Server SQL Server 2005 1 SQL Server 2005 DBA Microsoft SQL Server 2005 49
1 SQL Server 2005 SQL Server CPU 1. 2. 3. SQL Server 2 SQL Server DBA SQL Server 2005 1. SQL Server 2005 2. 3. 50
1 SQL Server 2005 SQL Server 2005 Practice 1SQL Server 2005 Practice 2SQL Server 2005 SQL Server 2005 SQL Server 2005 Practice 1 SQL Server 2005 Practice 2 SQL Server 2005 Practice 3SQL Server 2005 SQL Server 2005 SQL Server 2005 Practice 1 /SQL Server Practice 2 /SQL Server Microsoft SQL Server 2005 51
1 SQL Server 2005 Practice 3 Copy Database Wizard SQL Server Practice 4SQL Server 70-431 MORE INFO 52