The SQL Enterprise Manager allows you to backup the entire database or the transaction log on its own. SAP recommends the use of the Enterprise Manager for individual, exceptional backups that are not part of the normal backup routine.
For backups that are scheduled periodically, in accordance with a predefined backup strategy, it is advisable to use the CCMS DB Administration Planning Calendar. This offers a range of useful functions for scheduling backups and easy access to other SAP transactions that let you monitor backups.
Keep in mind that a backup scheduled and executed in the Enterprise Manager is not recorded in the Planning Calendar.
1. In the Enterprise Manager, expand the server.
2. Expand the databases to display a list of existing databases. Select the database that you want to create a backup for and choose Action ® All tasks ® Backup database.
The SQL Server Backup dialog box appears.
3. Choose the General tab. Select the database you wish to backup.
4. Enter a name and description for the backup.
5. Select the type of backup you want to create. In the SAP environment this can either be Database - Complete, Database Differential or Transaction Log.
Database- Complete backs up the used space in the database including the data and log files. This type of backup does not truncate the transaction log.
Database- Differential records the changes made to the data in the database since the last full database backup including the log files.
Transaction Log backs up the transaction log only. The procedure includes the truncation of the log.
6. Under Destination, select whether the backup is to be written to tape or disk. Make sure that the devices you intend to use are listed. If not, choose either Add to create a new device or Remove to delete an existing one. Usually R3DUMP0 is the correct device.
7. The backup can either be executed immediately or scheduled to run at a later time. To schedule the backup, select schedule and then choose the button to the right of the schedule entry field.
The Edit Schedule dialog box appears.
8. Complete the Edit Schedule dialog box. Give the schedule a name and then enter scheduling details:
Start automatically when SQL Server Agent starts schedules the backup to begin automatically when the SQL Server Agent starts.
Start whenever CPU(s) become idle begins the backup whenever the CPU(s) are inactive.
One Timeschedules the backup to run once. Set a date in the On Date box and a time in the At Time box.
Recurringschedules the backup to run at regular intervals.
To specify the details for the recurring backup, choose the Change button. You can then enter information in the Task Schedule dialog box that opens.
9. To complete the definition of the backup, switch to the Options tab. This offers various options that influence the execution of the backup. Choose the options as required. If you are uncertain which ones are suitable, access the information provided by the Help button.
Always choose Verify Backup on Completion, as this makes sure that all the files are written to tape and can be read.
10. When you have completed the definition of the backup, choose OK to execute the backup immediately. If you have specified a particular time for the backup or scheduled it repeatedly, choose OK to save your entries. The backup will automatically be started at the time you have specified.
The SQL Server Agent executes a backup that has been scheduled as a job. To monitor a backup that is currently running, you have to access the SQL Server Agent that is responsible for executing scheduled jobs.
1. In the Enterprise Manager, expand the server and then Management and SQL Server Agent.
2. Select Jobs.
The right-hand pane displays an overview of all scheduled jobs.
3. The Status and Last Run Status column indicate whether the backup is running or has aborted with an error.
Backup tasks scheduled in the Enterprise Manager are not registered in the Planning Calendar.