Database Administration for Microsoft SQL Server 

You need to perform various tasks to administer your MS SQL Server database in an SAP environment.

Tools

You can use the following SAP tools for MS SQL Server database administration:

·        Enterprise Manager (SQL Server 2000)

·        SQL Server Management Studio (SQL Server 2005)

·        DBA Planning Calendar (MS SQL Server)

·        Monitor for Backup and Restore Information

·        Monitor for Database Performance: Database Allocation

·        Monitor for SQL Server Alerts

·        Monitor for the SAP/SQL Server Database

Tasks on Demand

The table below shows tasks that you need to perform when required:

Task	More Information
Start or stop SQL Server	Database Server Management
Restore the database	Database Restore
Perform a system copy	service.sap.com/instguides  ® SAP NetWeaver ® <Release> ® Installation> ® <SAP System> ® Homogeneous and Heterogeneous System Copy

Periodic Tasks

The table below shows tasks that you need to perform periodically or daily:

Whenever possible, use the Planning Calendar for these tasks.

Task	More Information
Backups	DBA Planning Calendar
Monitor the MS SQL Server database	SAP/SQL Server Database Monitor
Database server checks	Database Server Checks

See also:

SAP / MS SQL Server DBA in CCMS