Backing Up the SQL Server Database

Use

The SQL Server Management Studio allows you to back up the entire database or the transaction log on its own. SAP recommends to use SQL Server Management Studio for individual exceptional backups that are not part of the normal backup routine.

Procedure

Executing the Backup

...

       1.      Start the SQL Server Management Studio.

       2.      Enter the connection information in the Connect to Server window to connect to the server.

       3.      In the Object Explorer, open Databases, select the database you want to backup and right-click Tasks → Back up.

The Back Up Database dialog window opens.

       4.      In the General tab of the Back Up Database dialog window select the:

○       Database you want to backup

○       Backup type

In an SAP environment you can choose a Full, Differential or Transaction Log backup.

○       Backup component

For an SAP environment, select Database.

○       Name and description of the backup set

○       Expiration period for the backup set

       5.      In the Destination info box, do the following:

                            a.      If the devices are not listed, add the disk or tape device

                            b.      Select the device you want the backup written to.

       6.      In the Options page of the Back Up Database dialog window:

○       Check and enter the information for overwriting the media

○       In the reliability box, select your backup options.

○       If the backup type is Transaction log, select your options in the Transaction log info box.

○       If you back up to a tape device, select your options in the Tape drive info box.

       7.      Select OKto start the backup.

Monitoring a Backup

The SQL Server Agent executes a backup that has been scheduled as a job. To monitor a backup that is currently running, access the SQL Server Agent that is responsible for executing scheduled jobs, and do the following:

...

       1.      In the Microsoft SQL Server Management Studio, expand the server.

       2.      In the Object Explorer, expand SQL Server Agent, and expand Jobs.

An overview of all scheduled jobs is displayed.

       3.      Double-click the Job Activity Monitor.

The Job Activity Monitor lists all scheduled jobs in the SQL Server Agent.

The Status and Last Run Outcome column indicate whether the backup is running or has aborted with an error.

Backup tasks scheduled in the SQL Server Management Studio are not registered in the Planning Calendar (DB13).