SAP/ MS SQL Server DBA in CCMS (BC-DB-MSS-DBA)
Database Backup
Backup Strategy
Backup Types
What Needs to be Backed Up?
Backup Device Management
Disk Configuration
Executing Backups
Backing Up with R/3
Backing Up with the Enterprise Manager
Monitoring Backups
Checking Individual Backups with R/3
Checking all Backups with R/3
Checking Backups with the Enterprise Manager
Database Restore
Distribution of Files to Disk
Restoring the R/3 Database after Disk Crash
Backing Up the Current Transaction Log
Restoring the Database and Log Backups
Restoring a Backup from Device
Restoring After Executables Disk Crash
Restoring the msdb Database from Device
Database Server Checks
Viewing the Error Log with R/3
Viewing the Error Log with the Enterprise Manager
Monitoring the R/3 Data Disk
Monitoring the R/3 Log Disk
Checking Consistency of the Database
Checking Consistency of Individual Tables
Checking for Missing Indexes
Database Server Management
Starting and Stopping the SQL Server
Setting SQL Server Startup Options
Changing Passwords
Registering a Server
Changing the Autogrow Settings
Configuring the SQL Server
Configuring Databases
Setting Single-User Mode
Executing Queries
Moving R/3 Database Files to New Disks
Displaying the SQL Server Version
Database Performance Tuning
Increasing the Size of the NT Page File
Optimizing the Virtual Memory Manager
Removing the Screen Saver
Database Management Tools
Enterprise Manager
R/3 Planning Calendar
Working with the R/3 Planning Calendar
R/3 Backup Monitor (MS SQL Server)
R/3 Static Database Monitor (MS SQL Server)
SQL Server Alert Monitor
Alerts for SQL Server
Viewing and Customizing Threshold Values
SAP/SQL Server Database Monitor