SAP/ MS SQL Server DBA in CCMS

Purpose

This component enables you to administer your Microsoft SQL Server database with the SAP system.

Implementation Considerations

For more information about installing MS SQL Server with the SAP system see the Installation Guide for <your SAP system>on Windows: MS SQL Server

Integration

The Computer Center Management System of the SAPsystem and the SQL Server Management Studio provide functions that help you to manage your database. The functions that are most commonly used are described in this documentation. For additional information see the SQL Server Books Online.

Features

The functions offered by the Computer Center Management System and the SQL Server Management Studio support you in performing all the essential tasks involved in managing a database. They enable you to:

Schedule and create backups
Restore a damaged database
Monitor a database
Configure a database
Perform routine tasks such as starting or stopping the SQL Server database