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 tools for the MS SQL Server database administration:

●      SQL Server Configuration Manager

●      SQL Server Management Studio

●      DBA Cockpit

 

Tasks on Demand

 

You need to perform the following tasks:

●      Start or stop the SQL Server database.

●      Restore the Database

●      Perform a system copy.

For more information, see http://service.sap.com/instguides → SAP NetWeaver → <Release> → Installation> → <SAP System> → Homogeneous and Heterogeneous System Copy

Periodic Tasks

You need to perform the following tasks periodically or daily:

Whenever possible, use the Planning Calendar for these tasks.

●      Backups

For more information, see the DBA Planning Calendar.

●      Monitor the MS SQL Server database

For more information, see the Database Performance Analysis.

●      Database Server Checks

See also:

SAP / MS SQL Server DBA in CCMS