SQL Server full and transaction log backups completing but differential backups failing because of Veeam B&R configuration


I recently refreshed our SQL Server Maintenance Plans, but System Centre Essentials has been intermittently reporting failures of the daily differential backups, with an error like this:

Executing the query “BACKUP DATABASE [DBNAME] TO DISK = N’…” failed with the following error: “Cannot perform a differential backup for database “DBNAME”, because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option. BACKUP DATABASE is terminating abnormally.”. Possible failure reasons: Problems with the query, “ResultSet” property not set correctly, parameters not set correctly, or connection not established correctly.

The strange thing is that the logs show all Weekly Full backups have completed without error. If I run a manual Full Backup, the next Differential Backup will complete, then the following day will fail.


First, I used the following query to show more details on the backups (make sure you select the DB in SSMS first):

[Read more…]

Using File-level restore mount in Veeam B&R 6.1

One of new features in Veeam Backup & Replication 6.1 is “File-level restore mount”:

When performed by the user interactively (using the backup console UI),
the Windows file-level restore process now mounts the volumes of the backed-up VM under C:\VeeamFLR.
This functionality is useful if you prefer to perform file-level recovery with native tools instead of Veeam
Backup Browser.

See this in action below.

[Read more…]

vCenter Server Appliance Service fails after upgrading ESXi hosts to 5.0 U1 Veeam backups now fail


You’ve just upgraded your ESXi hosts from 5.0 to 5.0 U1. They updated fine and there are no issues with the VMs. However, you have noticed that your Veeam backups have started to fail.

Further investigation shows the vCenter Server Appliance (vCSA) service is not running.

[Read more…]

Copy Veeam backups to USB drive

As we are still rolling out VMware and Veeam B&R throughout our offices, we are not yet in a position to set up replication.

Until we are ready, I thought it was a good idea to at least backup the Veeam backup repository to USB3 drives, which would be rotated and taken offsite daily.

Initially I setup a ‘Veeam File Copy’ job, but later noticed it was taking ages to copy the new incremental files. It seems ‘Veeam File Copy’ jobs do not just copy the new files, but all files every time; not what I wanted.

[Read more…]

How to create a Backup Job for Veeam Backup & Replication 6

So, you’ve installed Veeam Backup & Replication 6, created a new Backup Repository, added a server, and now you want to create a Backup Job for Veeam Backup & Replication 6. Continue reading below to find out how.

[Read more…]

How to create a Backup Repository for Veeam Backup & Replication 6

Before you can start backing up Virtual Machines (VMs), you need to create a Backup Repository after installing Veeam Backup & Replication 6.

During installation, Veeam Backup & Replication 6 will create a Default Backup Repository with a path of C:\backup. As you may not want to store your backups on the C drive – where your Operating System files usually reside – follow these instructions to create another Backup Repository on a separate drive.

[Read more…]

How to install Veeam Backup & Replication 6

Veeam’s Backup & Replication software is No.1 when it comes to backing up VMware – and now Hyper-V – Virtual Machines (VMs). Follow these steps to install Veeam Backup & Replication 6.

[Read more…]