Microsoft SQL Backup and Restore

Ahsay brings you specialized client backup software, namely AhsayOBM, to provide a comprehensive backup solution for your MS SQL Server. The MS SQL Server module of AhsayOBM provides you with a set of tools to protect your MS SQL Server, whether in VSS backup mode or ODBC backup mode.

We recommend you read first the Overview (GUI) section. This will help you become familiar with the different functions, settings and features that can be configured in AhsayOBM. It will also be helpful to know the different features that can be customized in the backup set before creating one.

This guide will only focus on:

  • How to create a Microsoft SQL backup set

  • How to run a backup job

  • How to recover files from a backup job

  • Types of backup mode in creating a backup set

  • Difference between VSS Backup Mode and ODBC Backup Mode

Run on Client (Agent-based) Backup

Below is the system architecture diagram illustrating the major elements involved in the backup process among the MS SQL server, AhsayOBM and AhsayCBS.

success

VSS and ODBC Backup Modes

The following steps are performed during a MS SQL Server backup job in VSS and ODBC Backup Modes.

VSS Backup Mode

For an overview of the detailed process for Steps 3, 5, 12, and 14, please refer to the File Backup and Restore (GUI) section.

  • Periodic Data Integrity Check (PDIC) Process (Step 3)

  • Backup Set Index Handling Process

    • Start Backup Job (Step 5)

    • Completed Backup Job (Step 14)

  • Data Validation Check (Step 12)

steps1

ODBC Backup Mode

For an overview of the detailed process for Steps 3, 5, 11, and 13, please refer to the File Backup and Restore (GUI) section.

  • Periodic Data Integrity Check (PDIC) Process (Step 3)

  • Backup Set Index Handling Process

    • Start Backup Job (Step 5)

    • Completed Backup Job (Step 13)

  • Data Validation Check (Step 11)

success