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

• 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