You need to perform various tasks to administer your MS SQL Server database in an SAP environment.
You can use the following tools for the MS SQL Server database administration:
● SQL Server Configuration Manager
● SQL Server Management Studio
You need to perform the following tasks:
● Start or stop the SQL Server 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
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.