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 |
Restore the database |
|
Perform a system copy |
service.sap.com/instguides ® SAP NetWeaver ® <Release> ® Installation> ® <SAP System> ® Homogeneous and Heterogeneous System Copy |
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 |
|
Monitor the MS SQL Server database |
|
Database server checks |