SAP/ MS SQL Server DBA in CCMS
Database Backup
Backup Strategy
Backup Types
Log Truncation
Recovery Models
What Needs to be Backed Up?
Backup Device Management
Disk Configuration
Executing Backups
Backing Up with the SAP System
Monitoring Backups
Database Restore
Distribution of Files to Disk
Restoring the SAP Database after Disk Crash
Restoring the Database and Log Backups
Restoring After Executables Disk Crash
Database Server Checks
Checking Consistency of the Database
Viewing the Error Log
Monitoring the SAP Data Disk
Monitoring the SAP Log Disk
Database Server Management
Multiple Instances in SQL Server
Starting and Stopping the SQL Server
Setting SQL Server Startup Options
Setting Authentication
Changing Passwords for SQL Server Logins
Changing Passwords of Windows Accounts
Registering a Server
Changing the Size of the Database Files
Configuring SQL Server
Configuring Databases
Setting Single-User Mode
Executing Queries
Moving SAP Database Files to New Disks
Displaying the SQL Server Version
Database Performance Tuning
Increasing the Size of the Windows Page File
Optimizing the Virtual Memory Manager
Removing the Screen Saver
Database Management Tools
Enterprise Manager
Backing Up with the Enterprise Manager
Backing Up the Current Transaction Log with Enterprise Manager
Checking Backups with the Enterprise Manager
Viewing the Error Log with the Enterprise Manager
Increasing the Number of Error Log Files
Restoring the Database and Log Backups with Enterprise Manager
Restoring a Backup from Device with Enterprise Manager
Restoring the msdb Database from Device with Enterprise Manager
The DBA Planning Calendar (MS SQL Server)
Setup of the DBA Planning Calendar (MS SQL Server)
Working with the DBA Planning Calendar
Scheduling an Action
Changing an Action
Executing an Action
Deleting an Action
Displaying the Status of a Day’s Actions
Displaying Scheduled Actions
Troubleshooting Scheduled Jobs
Displaying the Volume (Tape Names) of Scheduled Backups
Storing a Backup on Multiple Tapes
Scheduling Database and Transaction Log Backups (Windows)
Scheduling Database Consistency Checks (Windows)
Checking Individual Backups with the SAP System
SAP Backup and Restore Information (MS SQL Server)
Checking all Backups with the SAP System
SAP Database Performance: Database Allocation
Checking Consistency of Individual Tables
Checking for Missing Indexes
SQL Server Alert Monitor
Alerts for SQL Server
Viewing and Customizing Threshold Values
SAP/SQL Server Database Monitor
Memory
Disk Space Usage
Dynamic Values in Current Activity Sub Screen
Detail Analysis Menu
Viewing the Error Log with the SAP System
Monitoring Remote SQL Server Databases
Remote Enabled Functions (RFC)
Database Multi-Connect
Combination of RFC and DB Multi-Connect
Connecting to Remote Databases
Setting Up the Remote Connection
Defining an RFC Connection
Preparing the Source SAP Web Application Server
Preparing the Target Database Server
Creating a DBCON Entry
Creating an Object Source Schema and the SAP T-SQL Objects
Useful Information for Setting Up the Remote Connection
Troubleshooting