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

12 September 2012 by

Scenario

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.

Solution

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

[Read more…]

Filed Under: Microsoft, SQL Server, Veeam Tagged With: , ,

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

13 July 2012 by

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…]

Filed Under: Veeam Tagged With: ,

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

5 July 2012 by

Scenario

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…]

Filed Under: Veeam, VMware Tagged With: , , ,

Copy Veeam backups to USB drive

19 March 2012 by

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…]

Filed Under: Programming, Veeam Tagged With: , ,

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

16 February 2012 by

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…]

Filed Under: Veeam, VMware Tagged With: ,

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

16 February 2012 by

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…]

Filed Under: Veeam, VMware Tagged With: ,

How to install Veeam Backup & Replication 6

16 February 2012 by

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…]

Filed Under: Veeam, VMware Tagged With: ,