SAP/ MS SQL Server 2000 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
Backing Up with the Enterprise Manager
Monitoring Backups
Checking Individual Backups with the SAP System
Checking all Backups with the SAP System
Checking Backups with the Enterprise Manager
Database Restore
Distribution of Files to Disk
Restoring the SAP 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 the SAP System
Viewing the Error Log with the Enterprise Manager
Monitoring the SAP Data Disk
Monitoring the SAP Log Disk
Checking Consistency of the Database
Checking Consistency of Individual Tables
Checking for Missing Indexes
Database Server Management
Multiple Instances In SQL Server 2000
Starting and Stopping the SQL Server
Setting SQL Server Startup Options
Changing Authentication
Changing Passwords for SQL Server Logins
Changing Passwords of Windows Accounts
Registering a Server
Changing the Autogrow Settings
Configuring the 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
Planning Calendar
Working with the Planning Calendar
Central DBA Planning Calendar (MS SQL Server)
Working with the Central DBA Planning Calendar (MS SQL Server)
SAP Backup and Restore Information (MS SQL Server)
SAP Database Performance: Database Allocation
SQL Server Alert Monitor
Alerts for SQL Server
Viewing and Customizing Threshold Values
SAP/SQL Server Database Monitor
Memory Usage
Space Usage
Server Engine
Detail Analysis Menu