大网数据广告活动
服务器运维问答

Will a Veeam 8 Snapshot Backup be be unable to restore my non-quiescable file-based databases if someone is logged in to them at the time?

· 52CE 我爱测

We have some very old file-based databases (multi-user, but not Server-based) that are running on some VMs on an VMWare ESXi. Setup HyperVisor The ESXi is running ESXi version 5.1.0 Virtual Machines The VM with Visual Fox Pro is …

问题原文

原帖链接 · leeand00 · CC BY-SA 3.0

We have some very old file-based databases (multi-user, but not Server-based) that are running on some VMs on an VMWare ESXi.

Setup

HyperVisor

The ESXi is running ESXi version 5.1.0

Virtual Machines

The VM with Visual Fox Pro is running Windows Server 2003 Standard Edition version 5.2.3790 Service Pack 2 Build 3790 32-bit.

The VM with MS Access is running Windows Server 2003 Enterprise Edition 5.2.3790 Service Pack 2 Build 3790 32-bit.

Both VMs have VMware Tools 9.0.0, build-782409 installed...

File-based Non-quiescable File-based Databases

The file-based databases are Visual Fox Pro 9.0757 (free table directory of .dbf and .cdx files) and an MS Access 2003 Database backend .mdb.

Backup Method

The Esxi is backed up using Veeam 8.

The Veeam Backup and Replication is version 8.0.0.917 with Patch 1 installed and backs up to a NAS on a SAN with iSCSI (if it matters).

And it is a Reverse Incremental Backup which takes a snapshot of the VM during the backup.

Initially this Reverse Incremental Backup method takes a full backup and stores it in a .vbk file, and with each additional backup it stores the changes in a .vrb file.

The following settings have been applied for the backup:

Quiescable Databases and VSS

Microsoft Volume Shadow Copy Service (VSS) fires events to applications (notifies applications) that may be running on a server, such as SQL Server, so that any pending SQL transactions that may be running are completed before the backup, and so that all incoming operations are stopped before taking a backup of the files that store the database, this is known as the verb, quiesce. This is the reason for using a server process to house your database instead of just using files and a program that connects to them, a backup of the files can be done quickly and without locking everyone out.

Backing up File Based Databases

So what happens you backup your database and it doesn't have the ability to complete existing transactions and reject new ones? If users/processes are not forced to close the database file, and prevented from accessing them, when the backup copies are made, the backup copies are unusable. And it will not even tell you that this has occurred...you are doomed to find out the backup doesn't work later, when you need to restore it.

已采纳解答

原帖链接 · Andrew Zhelezko · CC BY-SA 3.0

In order to avoid such nightmare, you should use pre-freeze/post-thaw scripts to setup for job which backs this VM up. If needed, check related topics in Veeam forum to ask others about their experience and scripts' examples.

摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。

资料来源与适用范围

资料来源
Server Fault
适用范围
以原帖系统、软件版本与发布日期为准(2015-01-11)
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY-SA 3.0

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。