Veeam B&R restore SQL items and Firewall

I have a customer with some SQL servers on a DMZ, that they need to restore databases to, and we looked at the documentation for which ports to open. This is the documentation for Veeam B&R 9.0, and we found the ports and it worked fine, until we had to restore to an SQL instance […]

Please share this page if you find it usefull:

Veeam Backup warning “Unable to truncate Microsoft SQL Server transaction logs.”

I had a customer that contacted me to day because he got a warning that Veeam Backup was "Unable to truncate Microsoft SQL Server transaction logs.Details: Failed to process 'TruncateSQLLog' command. Failed to truncate SQL server transaction logs for instances:  BI See guest helper log." This normally means that the account used for Application Aware backup is not […]

Please share this page if you find it usefull:

Veeam B&R SQL Log Shipping and Firewall Rules

I was looking at which ports that should be open in a Firewall, for SQL log Shipping to work, so I was looking at the "VM Guest OS Connection" section of the documentation: https://helpcenter.veeam.com/backup/vsphere/used_ports.html#guest But that is not all that needs to be opened you also have to look at the "Backup Server Connections" section and […]

Please share this page if you find it usefull:

Microsoft SQL database restore with Veeam Backup & Replicator 8.0

There are some prerequisite that is need to be in place before you can do at restore of Microsoft SQL Server databases with Veeam, on the SQL server: TCP/IP enabled as SQL Server protocol enabled remote accesss to SQL Server SQL Server Browser Server enbled and running

Please share this page if you find it usefull: