Full Data Backup

Individual databases can be distributed across several servers or storage media to allow for restoration of all data following an SQL Server failure. This is the optimum system topology.

Full Data Backup Topology

Abbreviation of the Data Files

Abbrev.

Short Description

Description

BAK

Backup File

Backup file of MDF file

LDF

Log Data File

Microsoft SQL Server transaction log file

MDF

Master Data File

Microsoft SQL Server database

NDB

Notification Database

Includes all logged notification data

System

System Desigo CC

Program and project data files of Desigo CC

OS

Operating System

 

 

NOTE:
The saved *.BAK files have the same data content for simple and full notification backup.