Show TOC

Background documentationDatabase Administration for Microsoft SQL Server Locate this document in the navigation structure

 

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:

Tasks on Demand

Task

More information

Start or stop SQL Server

Database Server Management

Restore the database

Database Restore

Perform a system copy

  http://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:

Task

More Information

Backups

DBA Planning Calendar

Monitor the MS SQL Server database

SAP/SQL Server Database Performance Monitor

Database server checks

Database Server Checks