ADM520 Database Administration MS SQL Server

Course version: 2003/Q2

Duration

• 3 day(s)

Course Goals

• Increasing your knowledge of database administration by using CCMS database tools in SAP systems and Microsoft SQL Server tools
• Developing suitable backup strategies
• Detecting and solving performance bottlenecks

Target Audience

• Database administrators
• SAP system administrators
• Project team members
• Technology consultants

Prerequisites

Essential:

• SAPTEC Fundamentals of SAP Web AS
• Fundamental knowledge of the Microsoft SQL Server database system and of the Windows NT 4.0/Windows 2000 operating system

Recommended:

• SAP system administrators should attend the course ADM100 (SAP Web AS Administration I)

Software Component(s) and Release(s)

• WEB AS 6.20

Course Content

• SAP system architecture and MS SQL Server architecture
• Data backups
• Backup concepts
• Backing up data
• Database restore
• Database monitoring
• Working with SQL Server monitors
• Working with CCMS monitors
• System maintenance and troubleshooting

Notes

• The course materials are in English. However, the course is held in the language of the country where it takes place.
• The course ADM520 (MS SQL Server Database Administration) replaces course BC520 (MS SQL Server Database Administration) and is held using a Microsoft SQL Server 2000 system.