Database Administration for Microsoft SQL Server

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 the system copy guide for your SAP product at:https://support.sap.com/sltoolset

Periodic Tasks

You need to perform the following tasks periodically or daily:

• Backups

  For more information, see the DBA Planning Calendar.

• Monitor the MS SQL Server database

  For more information, see the Database Performance Overview.

• Database Server Checks