Business Continuity for the MS SQL Server Database

Use

This section looks at database administration for the Microsoft SQL Server database and makes specific recommendations on improving availability.

You can find more information about MS SQL Server with the SAP system at:

http://www.sdn.sap.com/irj/sdn/sqlserverInformation published on SAP site

Process

  1. You work out your approach to backing up your database. You must do this before you start production with the database. When using the database for production, you must back up the database as regularly as possible.

    See Backup with MS SQL Server .

  2. You manage the space in your database. You do this both before you start production with the database and later as the database grows.

    See Space Management with MS SQL Server .

  3. You recover your database if a failure occurs with data loss.

    See Recovery with MS SQL Server .

  4. You upgrade your database when required.

    See Upgrade with MS SQL Server .

  5. You consider using various tools and services offered as standard by SAP to increase the availability of your database:

    For example, see: SQL Server Management Studio

  6. You consider using advanced products and services to increase the availability of your database:

More Information

SAP/ MS SQL Server DBA in CCMS